Implementation of Oracle Auto-growth sequence

Oracle Auto-growth sequence Implementation about auto-growth sequence, I went back yesterday and tried to implement the Code item table
-- Create table Code_Main (CodeID number primary key, CodeName VARCHAR2 (50); -- create sequence www.2cto.com create sequence Code_Main_seq MINVALUE 1 MAXVALUE 9999999999 start with 1 increment by 1 CACHE 30 ORDER; -- create trigger create or replace trigger Code_Main_tg before insert on Code_Main for each row www.2cto.com begin select Code_Main_seq.NEXTVAL INTO: NEW. codeID from dual; END; insert into Code_Main (CodeName) VALUES ('zhang san'); author Christmas Eve