SQL Sequence 17-Oct-2023

CREATE SEQUENCE dept_deptid_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCACHE NOCYCLE;

select * from user_sequences;

CREATE TABLE business(bid number(5), btype varchar2(10));

INSERT INTO business(bid,btype) VALUES (435,'D2C');
INSERT INTO business(bid,btype) VALUES (731,'G2C');
INSERT INTO business(bid,btype) VALUES (743,'C2B');
INSERT INTO business(bid,btype) VALUES (763,'D2D');
INSERT INTO business(bid,btype) VALUES (432,'B2B');
INSERT INTO business(bid,btype) VALUES (635,'C2D');
INSERT INTO business(bid,btype) VALUES (535,'D2B');

INSERT INTO business VALUES (dept_deptid_seq.nextval, 'c2c')

select dept_deptid_seq.nextval from dual