Steps for adding a primary key auto-increment in oracle

Step 1: Add a primary key for auto-growth in oracle step 1: www.2cto.com create sequence seq _ table name increment by 1 -- add a few start with 1 each time -- count NOMAXVALUE from 1 -- do not set the maximum value NOCYCLE -- always accumulate, do not cycle NOCACHE -- do not CREATE a buffer Step 2 create trigger "tiger _ table name" beforeinsert on table name for each row when (new. the auto-increment field is null) beginselect seq _ table name. nextval into: new. auto-increment field from dual; end; Step 3 commit;