学步园

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 />