CREATE OR REPLACE TRIGGER CLE_FUND_ADJU_APPLY_ID_TRIGGER(触发器名) before
insert on CLE_FUND_ADJU_APPLY(表名) for each row
begin
select SEQ_CLE_FUND_ADJU_APPLY(序列名).nextval into:new.id(自增字段名) from dual(oracle中的虚拟表);
end CLE_FUND_ADJU_APPLY_ID_TRIGGER(触发器名);
11-30
1722
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)