請問以下代碼應該怎樣寫才能通過編譯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; /
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;
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;
/
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;
楼上这两位的就可以了