Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

Use combined column as the primary key

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.