SQL>
SQL> create table myTable(
2 id number(6) not null,
3 salary number(8,2),
4 hire_date date default sysdate,
5 termination_date date,
6 termination_desc varchar2(4000),
7 constraint emphistory_pk primary key (id, hire_date)
8 );
Table created.
SQL>
SQL> describe myTable;
Name Null? Type
--------------------------------------------------------------------------
ID NOT NULL NUMBER(6)
SALARY NUMBER(8,2)
HIRE_DATE NOT NULL DATE
TERMINATION_DATE DATE
TERMINATION_DESC VARCHAR2(4000)
SQL>
SQL> drop table myTable;
Table dropped.