CREATE OR REPLACE TRIGGER TRIGGER_NAME
BEFORE/after INSERT or delete or update ON T_EQUIP
FOR EACH ROW-行级
DECLARE
--
begin
DML;
[DML;]
....
end;
BEFORE/after INSERT or delete or update ON T_EQUIP
FOR EACH ROW-行级
DECLARE
--
begin
DML;
[DML;]
....
end;
before update on 表1
for each row
begin
update 表1 set b=1 where a=:new.a;
--如果是修改后的值取更新:
--update 表1 set b=1 where a=:old.a;
end;
/
before update on 表1
for each row
begin
update 表2 set b=1 where a=:new.a;
--如果是修改后的值取更新:
--update 表2 set b=1 where a=:old.a;
end;
/
before[/after][/instead of] update on tablename(viewName---instead of only)
for each row
declare
v_parameter type(length)
begin
insert into table2 (a) values (:new.colname)[:old.colname]
end;