SQL> @ trigger2 Trigger created. No errors. ======== exercising trigger2.sql's SECOND version of trigger empl_trig (removing FOR EACH ROW) Commit complete. ======== SHOULD see message about updating empl rows, one message per update statement (NOT per row updated): ======================= ABOUT to run an update statement on empl! 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