Oracle uses Sequence and trigger to automatically increase the ID

Oracle uses Sequence and triggers to automatically increase IDs. Many companies use Oracle databases and require automatic increase of IDs. However, there is no ready-made method to use auto_increatment like SQL Server. Under www.2cto.com, I wrote a Sequence and a trigger to achieve automatic growth. (If you have a better method, please leave a message. Thank you.) 1. create a SequenceSql Code Create Sequence reader_sequence MINVALUE 1 MAXVALUE 999999999999999999999999999 start with 1 increment by 1 CACHE 20; 2. create a table SQL code -- permission create table privilege (id number (255) not null, -- sequential number name varchar2 (255 char) not null unique, -- permission name description varchar2 (char) null, -- permission description code varchar2 (64 char) not null unique, -- code feature varchar2 (64 char) not null, -- feature name module varchar2 (64 char) not null -- Module name primary key (id); www.2cto.com 3. add a trigger to the table to automatically obtain the ID SQL code create or replace trigger privilege_trigger before insert on privilege referencing old as old new as new for each row begin select reader_sequence.nextval into: new. id from dual; end;