Create Sequence in Oracle

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;