創建 Oracle Trigger 時出錯？？When Instering ……

[cityhunter172]

請問以下代碼應該怎樣寫才能通過編譯

create or replace trigger Users_Tri04
before update or insert or delete
on Users
for each row
when Instering
begin
dbms_output.put_line('Update2');
end;
when Updating
begin
dbms_output.put_line('Insert2');
end;
when Deleting
begin
dbms_output.put_line('Delete2');
end;

[leborety]

Instering-----》 inserting

[cityhunter172]

改正了，也不行

總是提示“ORA-00906:遺漏左括弧”

[jxc]

請問以下代碼應該怎樣寫才能通過編譯

create or replace trigger Users_Tri04
before update or insert or delete
on Users
for each row
begin
if inserting then
dbms_output.put_line('insert');
end if;

if updating then
dbms_output.put_line('update');
end if;

end;
/

[soniczck]

不是用WHEN.
楼上这两位的就可以了

[dinya2003]

create or replace trigger Users_Tri04
before update or insert or delete on Users
for each row
begin
if inserting then
dbms_output.put_line('insert');
elsif updating then
dbms_output.put_line('update');
else
dbms_output.put_line('delete');
end if;
end;