varchar2 type column with default value : VARCHAR2 « SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL Data Types
3. VARCHAR2

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>
SQL> drop   table employee_locker;

Table dropped.

SQL>
SQL>