Sunday, May 9, 2010

Primary key in oracle




CREATE TABLE emp_table
( emp_id numeric(10) not null,
emp_name varchar2(50) not null,
company_name varchar2(50),
CONSTRAINT emp_pk PRIMARY KEY (emp_id, emp_name)
);

No comments:

Post a Comment