有关触发器的新建和使用
基本格式:
create [or replace] trigger
trigger_name
before|after
event1 [ or event2 or event3 …]
on table_name [for each row]
begin
statement;
…
end;
event通常指insert、update、delete等操作
实例: 将用户对emp2表的dml操作的时间,操作,用户记录下来,记录在emp2_log中,该触发器会自动调用
create or replace trigger trig
after insert or delete or update on emp2
begin
if inserting then
insert into emp2_log values (USER, 'insert', sysdate);
elsif updating then
insert into emp2_log values (USER, 'update', sysdate);
elsif deleting then
insert into emp2_log values (USER, 'delete', sysdate);
end if;
end;