DML触发器实现日志功能

trigger实现日志功能：DML触发器由DML语句触发

create table student
(sid number(4) primary key,
sname varchar2(20),
sage number(4)
);
insert into student values (1001,'candy',24);
insert into student values (1002,'tracy',22);
insert into student values (1003,'sarah',21);

create table record_student   --记录对student表的操作
(content varchar2(255),
rtime timestamp
);

create trigger update_student_tri
after update   --当执行update操作时，触发器触发
on student
for each row   --行级触发
begin
insert into record_student values
('执行了upadate操作。执行该操作前的数据为：sid='||:old.sid||',sname='||:old.sname||',sage='||:old.sage,SYSDATE);
end update_student_tri;

update student set sage=26;

update student set sage=27;