【ref】在Oracle中实现自动增一

CREATE SEQUENCE SEQ_Data
 INCREMENT BY  1
 START WITH  1
 MAXVALUE  99999999

CREATE TRIGGER TRG_add_Pexpense BEFORE
INSERT  ON Tdata_Ccprojecexpenses
FOR EACH ROW begin
   SELECT SEQ_Data.NEXTVAL
     INTO :NEW.pex_ID
     FROM DUAL;
End;