创建两个表
create table student
( s_id number(4),
sname varchar2(10),
sage number(20)
);
create table record
( content varchar2(50),
rtinme timestamp
);
插入三条数据
insert into student values (111, 'hhhh', 20);
insert into student values (222, 'tttt', 19);
insert into student values (333, 'gggg', 55);
after触发器(在执行update or insert or delete 语句后触发),以下创建一个update触发器(执行update后触发)
create trigger update_trigger
after update on student
for each row
begin
insert into record
values
('执行了update操作。执行该操作前的数据为:' || :old.s_id, sysdate);
--列的数必须对应, :old.s_id为原先的s_id值如果为new的话就是现在的new.s_id
end update_trigger;
执行更新语句:
update student set sage = 25;
查看更新操作是否已执行,
column content format a40;
column rtime format a35;
select * from record;