create or replace trigger test
before update or insert on table_name
REFERENCING OLD AS old NEW AS new
for each row
declare
-- local variables here
begin
if :new.a = 0 then
:new.b := 1;
end if;
end test;
before update or insert on table_name
REFERENCING OLD AS old NEW AS new
for each row
declare
-- local variables here
begin
if :new.a = 0 then
:new.b := 1;
end if;
end test;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货