oracle 使用触发器生成序号- -

                                    

备用:

 

 CREATE OR REPLACE TRIGGER TR_INSERT_TABLE

 BEFORE INSERT ON    TR_INSERT_TABLE  FOR EACH ROW
 begin
     select SEQ_MYTABLE.nextval into :new.ID from dual;
 end;