Oracle中触发器（2）
SQL> select * from record ;no rows selected
SQL> select * from student ;
STUDENT_ID NAME CREATED_BYCREATED_DATE
---------- --------------- ------------------------------ -------------------
MODIFIED_BY MODIFIED_DATE
------------------------------ -------------------
100 mjt TRIGGER_TEST 2015-07-29 20:51:19
TRIGGER_TEST 2015-07-29 20:51:19
101 cxq TRIGGER_TEST 2015-07-29 21:00:54
TRIGGER_TEST 2015-07-29 21:00:54
SQL> update student set name = 'somebody' where name = 'mjt' ;
1 row updated.
SQL> commit ;
Commit complete.
SQL> select * from student ;
STUDENT_ID NAME CREATED_BYCREATED_DATE
---------- --------------- ------------------------------ -------------------
MODIFIED_BY MODIFIED_DATE
------------------------------ -------------------
100 somebody TRIGGER_TEST 2015-07-29 20:51:19
TRIGGER_TEST 2015-07-29 20:51:19
101 cxq TRIGGER_TEST 2015-07-29 21:00:54
TRIGGER_TEST 2015-07-29 21:00:54
SQL> select * from record ;
TABLE_NAME TRANSACTIO TRANSACTION_USER
------------------------------ ---------- ------------------------------
TRANSACTION_DATE
-------------------
student UPDATETRIGGER_TEST
2015-07-29 21:50:46
SQL> delete student where name = 'somebody' ;
1 row deleted.
SQL> commit ;
Commit complete.
SQL> select * from student ;
STUDENT_ID NAME CREATED_BYCREATED_DATE
---------- --------------- ------------------------------ -------------------
MODIFIED_BY MODIFIED_DATE
------------------------------ -------------------
101 cxq TRIGGER_TEST 2015-07-29 21:00:54
TRIGGER_TEST 2015-07-29 21:00:54
SQL> select * from record ;
TABLE_NAME TRANSACTIO TRANSACTION_USER
------------------------------ ---------- ------------------------------
TRANSACTION_DATE
-------------------
student UPDATETRIGGER_TEST
2015-07-29 21:50:46
student DELETETRIGGER_TEST
2015-07-29 21:56:08
SQL> alter trigger student_aud disable ;
Trigger altered.
SQL> update student set name = 'mjt' where name = 'cxq';
1 row updated.
SQL> commit ;
Commit complete.
SQL> select * from student ;
STUDENT_ID NAME CREATED_BYCREATED_DATE
---------- --------------- ------------------------------ -------------------
MODIFIED_BY MODIFIED_DATE
------------------------------ -------------------
101 mjt TRIGGER_TEST 2015-07-29 21:00:54
TRIGGER_TEST 2015-07-29 21:00:54
SQL> select * from record ;
TABLE_NAME TRANSACTIO TRANSACTION_USER
------------------------------ ---------- ------------------------------
TRANSACTION_DATE
-------------------
student UPDATETRIGGER_TEST
2015-07-29 21:50:46
student DELETETRIGGER_TEST
2015-07-29 21:56:08
页:
[1]