Create Sequence in Oracle

Bubbly
Posted by Bubbly under Others category on | Views : 1777
Sequence generates sequence numbers automatically.

For example, create a sequence named EMP_EMPID_SEQ to be used as primary key of Employee table
CREATE SEQUENCE emp_empid_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCACHE NOCYCLE;

Comments or Responses

Login to post response