【在线相册】触发器

SQL> ed Wrote file afiedt.buf 1 CREATE TABLE update_info ( 2 UA_id varchar(20) REFERENCES users, 3 old_pwd varchar(20), 4 new_pwd varchar(20), 5 time timestamp 6* ) SQL> / Table created. SQL> ed Wrote file afiedt.buf 1* SELECT * FROM users SQL> / USER_NAME USER_PWD UA_ID -------------------- -------------------- ---------- ymc 123456 9294234 root 123456 12345678 SQL> ed Wrote file afiedt.buf 1 CREATE OR REPLACE trigger tri_updateinfo 2 after UPDATE 3 of user_pwd 4 on users 5 FOR each row 6 BEGIN 7 INSERT 8 INTO update_info 9 VALUES(:old.UA_id,:old.user_pwd,:new.user_pwd,sysdate); 10* END; SQL> / Trigger created. SQL> select table_name from user_tables 2 / TABLE_NAME ------------------------------ UPDATE_INFO PHOTOS USER_ALBUM ALBUM_TYPE USERS SQL> ed Wrote file afiedt.buf 1* SELECT * FROM UPDATE_info SQL> / no rows selected SQL> commit 2 ; Commit complete. SQL> ed Wrote file afiedt.buf 1 UPDATE users 2 SET user_pwd = '654321' 3* WHERE UA_id = '12345678' SQL> / 1 row updated. SQL> ed Wrote file afiedt.buf 1* SELECT * FROM update_info SQL> / UA_ID OLD_PWD NEW_PWD -------------------- -------------------- -------------------- TIME --------------------------------------------------------------------------- 12345678 123456 654321 02-6月 -11 08.26.34.000000 下午 SQL>