create or replace trigger temp_trigger
before insert or update
on tab_name
for each row
//PL/sql模块
begin
end;
before insert or update
on tab_name
for each row
//PL/sql模块
begin
end;
调试欢乐多
before insert or update
on boatapply
for each row
begin
insert into log(content) values(:new.....);
end;
{before | after | instead of} triggering_event
referencing_clause
[when trigger_condition]
[for each row]
trigger_body;