SQL> @ trigger3 Trigger created. No errors. ======== exercising trigger3.sql's THIRD version of trigger empl_trig Commit complete. ===== SHOULD see messages about updating empl rows, one message per row updated, including the hiredate for that row before and after being updated, and the number of departments: ======================= ABOUT to update an empl row! hiredate BEFORE: 17-NOV-11 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 02-APR-12 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 01-MAY-13 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 09-JUN-12 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 03-DEC-12 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 17-DEC-12 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 20-FEB-18 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 22-FEB-19 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 28-SEP-18 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 09-NOV-18 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 08-SEP-19 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 23-SEP-18 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 03-DEC-17 hiredate AFTER: 25-FEB-25 num_depts is: 5 ======================= ABOUT to update an empl row! hiredate BEFORE: 23-JAN-16 hiredate AFTER: 25-FEB-25 num_depts is: 5 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