CREATE SEQUENCE <sequence_name>
INCREMENT BY <integer>
START WITH <integer>
MAXVALUE <integer> / NOMAXVALUE
MINVALUE <integer> / NOMINVALUE
CYCLE / NOCYCLE
CACHE <#> / NOCACHE
ORDER / NOORDER; 
 
 
-- basic autonumber with sequence:
INSERT INTO <table_name>
(<column_name>)
VALUES
(<sequence_name>.NEXTVAL);
 
-- basic autonumber with sequence demo.
-- these insert statements will insert 2 new records into 
-- the 'test_bed' table. The user_id field would be assigned 
-- the next number from the seq__user_id sequence. 
 
CREATE SEQUENCE seq_user_id;
 
SELECT seq_user_id.NEXTVAL FROM dual;
 
INSERT INTO test_bed
(user_id, class_type, room_location)
VALUES
(seq_user_id.NEXTVAL, 'Underwater Basketweaving', 'RM1205');
 
SELECT *
FROM test_bed;
 
INSERT INTO test_bed
(user_id, class_type, room_location)
VALUES
(seq_user_id.NEXTVAL, 'Creative Anarchy', 'RM3111');
 
SELECT * FROM test_bed;