oracle觸發器和自動成長列

//建立addmanage表create table addmanage(aid varchar2(10) primary key,managename varchar2(30),managepass varchar2(100))//建立自動成長段create sequence addmanage_sequencestart with 1increment by 1nomaxvaluecache 20//建立觸發器create or replace trigger addmanage_triggerbefore inserton addmanage<!--addmanage建立的表名-->for each rowwhen(new.aid is null)<!--aid表的主鍵-->beginselect addmanage_sequence.nextval into:new.aid from dual;end;