
只需将触发器更新为仅在未提供ID时触发。
create or replacetrigger sa.my_triggerbefore insert on sa.my_tablefor each rowwhen (new.id is null)begin select sa.my_sequence.nextval into :new.id from dual;end;
欢迎分享,转载请注明来源:内存溢出

只需将触发器更新为仅在未提供ID时触发。
create or replacetrigger sa.my_triggerbefore insert on sa.my_tablefor each rowwhen (new.id is null)begin select sa.my_sequence.nextval into :new.id from dual;end;
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)