Oracle Auto-growth trigger

Add columns automatically for building: create sequence emp_sequence increment by 1 ---- add several minvalue 1 at a time ---- the minimum value is 1 nomaxvalue ---- do not limit the maximum value start with 1 ---- cache 10 from 1 ---- cache order;
Build trigger: create or replace trigger sysrole_id before insert on sysrole ---- (sysrole is the table name) for each row ---- trigger each row begin select emp_sequence.nextval into: new. roleid -www.2cto.com-from dual; end; roleid is the table ID author meaijuan