oracle触发器将sequence生成值插入数据库表中（id字段）方法

1.sequence

-- Create sequence create sequence SEQ_T_XZ_YJB minvalue 1 maxvalue 999999999999999999999999999 start with 124 increment by 1 nocache;

2.该sequence的trigger(每次插入表T_XZ_YJB之前为其id字段赋予sequence生成值)

CREATE OR REPLACE TRIGGER BIFER_T_XZ_YJB BEFORE INSERT ON T_XZ_YJB REFERENCING OLD AS OLD_VALUE NEW AS NEW_VALUE FOR EACH ROW BEGIN SELECT SEQ_T_XZ_YJB .NEXTVAL INTO :NEW_VALUE.ID FROM DUAL; END;

通过该方法不用在应用程序中为数据库表的属性字段id赋值，数据库会在每次插入操作时自动为该表的字段id赋值。