Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

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>