oracle 创建触发器和序列

序列：create sequence SEQ_KS_EXAMINATION_Auto
minvalue 1
maxvalue 999999999999999
start with 1
increment by 1
nocache;

触发器：CREATE OR REPLACE TRIGGER tg_KS_EXAMINATION_Auto
BEFORE INSERT ON KS_EXAMINATION_Auto
 FOR EACH ROW
begin
select  SEQ_KS_EXAMINATION_Auto.nextval  into :new.i_id from dual;

end;