Creating Table with combined primary key
SQL> create table employee_history
2 (employee_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
8 primary key (employee_id, hire_date)
9 );
Table created.
SQL>
SQL>
SQL> drop table employee_history;
Table dropped.
SQL>
Related examples in the same category