SQL> @ trigger1 Trigger created. No errors. ======== exercising trigger1.sql's FIRST version of trigger empl_trig Commit complete. ======== SHOULD see messages about updating empl rows, one message per row updated: ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! ======================= ABOUT to update an empl row! 14 rows updated. contents of empl after updates (and before rollback!): ======== EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP ---- --------------- ---------- ---- --------- ---------- ---------- --- 7839 King President 25-FEB-25 5000 500 7566 Jones Manager 7839 25-FEB-25 2975 200 7698 Blake Manager 7839 25-FEB-25 2850 300 7782 Raimi Manager 7839 25-FEB-25 2450 100 7902 Ford Analyst 7566 25-FEB-25 3000 200 7369 Smith Clerk 7902 25-FEB-25 800 200 7499 Michaels Sales 7698 25-FEB-25 1600 300 300 7521 Ward Sales 7698 25-FEB-25 1250 500 300 7654 Martin Sales 7698 25-FEB-25 1250 1400 300 7788 Scott Analyst 7566 25-FEB-25 3000 200 7844 Turner Sales 7698 25-FEB-25 1500 0 300 EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP ---- --------------- ---------- ---- --------- ---------- ---------- --- 7876 Adams Clerk 7788 25-FEB-25 1100 400 7900 James Clerk 7698 25-FEB-25 950 300 7934 Miller Clerk 7782 25-FEB-25 1300 100 14 rows selected. Rollback complete. SQL> spool off