只需将触发器更新为仅在未提供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;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
