假如想写个触发器对当前的行记录进行修改的话,触发器是不能在重复使用update因为会资源死锁。
正确如下:
create or replace trigger Test_gavin
before insert or update on bank
for each row
declare
begin
:new.bank_name := upper(:new.bank_name);
end Test_gavin;
错误如下:
create or replace trigger Test_gavin
before insert or update on bank
for each row
declare
begin
update bank set bank_name = upper(bank_name) where gen_id = :new.gen_id;
end Test_gavin;
正确如下:
create or replace trigger Test_gavin
before insert or update on bank
for each row
declare
begin
:new.bank_name := upper(:new.bank_name);
end Test_gavin;
错误如下:
create or replace trigger Test_gavin
before insert or update on bank
for each row
declare
begin
update bank set bank_name = upper(bank_name) where gen_id = :new.gen_id;
end Test_gavin;