/*===
    PROOF of CONCEPT: a second version of our first trigger!

    trigger: empl_trig: before update on empl

    purpose: if serveroutput is set to on,
        before each update ***statement*** for empl,
        prints one message to the screen

        (that is, what happens if you remove
        for each row
        from the trigger header)
===*/

create or replace trigger empl_trig
    before update
    on empl    
begin
    dbms_output.put_line('=======================');
    dbms_output.put_line('ABOUT to run an update statement on empl!');
end;
/
show errors

set serveroutput on

prompt
prompt ========
prompt exercising trigger2.sql's SECOND version of trigger empl_trig
prompt (removing FOR EACH ROW)

commit;

prompt ========
prompt SHOULD see message about updating empl rows,
prompt one message per update statement (NOT per row updated):
prompt

update empl
set hiredate = sysdate;

prompt contents of empl after updates (and before rollback!):
prompt ========

select *
from   empl;

rollback;