+=+=+=+=+=+=+=+= Drew Hengehold +=+=+=+=+=+=+=+= drop table dept_changes * ERROR at line 1: ORA-00942: table or view does not exist Table created. Trigger created. No errors. Commit complete. ========== PRE-TEST contents of dept and dept_changes: DEP DEPT_NAME DEPT_LOC --- --------------- --------------- 100 Accounting New York 200 Research Dallas 300 Sales Chicago 400 Operations Boston 500 Management New York no rows selected ========== Updating Sales to have the name Moo: 1 row updated. ========== Updating Accounting to have the name Oink: 1 row updated. ========== Updating Research to have the location Arcata: 1 row updated. ========== POST-TEST contents of dept and dept_changes: * should see changed department names of Moo and Oink, and new location of Arcata * should see just TWO rows in dept_changes, logging changes from Sales to Moo and Accounting to Oink on today's date DEP DEPT_NAME DEPT_LOC --- --------------- --------------- 100 Oink New York 200 Research Arcata 300 Moo Chicago 400 Operations Boston 500 Management New York DEP CHANGE_DA PREV_DEPT_NAME NEXT_DEPT_NAME --- --------- --------------- --------------- 300 03-MAR-25 Sales Moo 100 03-MAR-25 Accounting Oink 200 03-MAR-25 Research Research Rollback complete.