create or replace 11 after insert or update on tablename REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW WHEN(22,33) begin if insertion then dbms_output.put_line(555); else dbms_output .put_line(555); end if; end;
create or replace 11 after insert or update of 22,33 on table when (:new.22>:33) begin if inserting then dbms_output.put_line(555); else dbms_output.put_line(555); end if; end;
错误有 "on" "of"的用法 output的拼写 insertion 最好表名不要用关键字
支持 ORARichard(没钱的日子......)
提示when 和触发器表不能在一起使用
create or replace trigger 11 after insert or update of 22,33 on table for each row when (:new.22>:33) begin if inserting then dbms_output.put_line(555); else dbms_output.put_line(555); end if; end;
create or replace trigger 11 after insert or update of 22,33 on table for each row when (new.22>new.33) begin if inserting then dbms_output.put_line(555); else dbms_output.put_line(555); end if; end; 这样写是正确的吧!
after insert or update on tablename
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW WHEN(22,33)
begin if insertion then
dbms_output.put_line(555);
else
dbms_output .put_line(555);
end if;
end;
after insert or update of 22,33 on table
when (:new.22>:33)
begin
if inserting then
dbms_output.put_line(555);
else
dbms_output.put_line(555);
end if;
end;
"on" "of"的用法
output的拼写
insertion
最好表名不要用关键字
after insert or update of 22,33 on table for each row
when (:new.22>:33)
begin
if inserting then
dbms_output.put_line(555);
else
dbms_output.put_line(555);
end if;
end;
after insert or update of 22,33 on table for each row
when (new.22>new.33)
begin
if inserting then
dbms_output.put_line(555);
else
dbms_output.put_line(555);
end if;
end;
这样写是正确的吧!