SQL>
SQL> create table employee_locker (
2 id number not null,
3 logical_indicator varchar2(1) default 'N' not null,
4 physical_indicator varchar2(1) default 'N' not null,
5 code varchar2(30) not null,
6 description varchar2(80) not null,
7 active_date date default SYSDATE not null,
8 inactive_date date );
Table created.
SQL>
SQL> insert into employee_locker ( id, logical_indicator, physical_indicator, code, description ) values ( 1, 'Y', 'N', 'B', 'Business Unit' );
1 row created.
SQL> insert into employee_locker ( id, logical_indicator, physical_indicator, code, description ) values ( 2, 'Y', 'N', 'C', 'Company' );
1 row created.
SQL> insert into employee_locker ( id, logical_indicator, physical_indicator, code, description ) values ( 3, 'Y', 'N', 'D', 'Department' );
1 row created.
SQL> insert into employee_locker ( id, logical_indicator, physical_indicator, code, description ) values ( 4, 'N', 'Y', 'L', 'Line' );
1 row created.
SQL> insert into employee_locker ( id, logical_indicator, physical_indicator, code, description ) values ( 5, 'N', 'Y', 'M', 'Machine' );
1 row created.
SQL> insert into employee_locker ( id, logical_indicator, physical_indicator, code, description ) values ( 6, 'N', 'Y', 'S', 'Site' );
1 row created.
SQL> insert into employee_locker ( id, logical_indicator, physical_indicator, code, description ) values ( 7, 'Y', 'Y', 'U', 'Unknown' );
1 row created.
SQL>
SQL> drop table employee_locker;
Table dropped.
SQL>