- 论坛徽章:
- 0
|
回复 1楼 polosky 的帖子
SQL> create table delrecord(deluser varchar(20),deltime varchar(20));
表已创建。
SQL> create or replace trigger record_del
2 after delete on test for each row
3 declare
4 cursor ucur
5 is
6 select Sys_context('USERENV','Current_user') a from dual;
7 urec ucur%rowtype;
8 cursor ucur1
9 is
10 select to_char(sysdate,'yyyymmddhh24miss') a from dual;
11 urec1 ucur1%rowtype;
12 begin
13 open ucur;
14 fetch ucur into urec;
15 open ucur1;
16 fetch ucur1 into urec1;
17 if ucur1%found and ucur%found
18 then
19 insert into delrecord values(urec.a,urec1.a);
20 end if;
21 close ucur;
22 close ucur1;
23 end;
24 /
触发器已创建
SQL> select * from test;
A B
-------------------- --------------------
a 1
c 1
b 1
e 1
f 1
SQL> delete from test where a='f';
已删除 1 行。
SQL> select * from delrecord;
DELUSER DELTIME
-------------------- --------------------
HUIXZ 20060307004332
以上是我写的一个触发器,仅供参考,你完全可以根据自己的想法做更细致的记录。 |
|