【線上相簿】觸發器

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