Editing Database trigger (section)

=== After - statement-level trigger ===
An Oracle syntax statement trigger that is called after an UPDATE to the phone_book table. When the trigger gets called it makes an insert into phone_book_edit_history table
<syntaxhighlight lang="sql">
CREATE OR REPLACE TRIGGER phone_book_history
  AFTER UPDATE ON phone_book
BEGIN
  INSERT INTO phone_book_edit_history 
    (audit_history_id, username, modification, edit_date) 
    VALUES
    (audit_history_id_sequence.nextVal, USER,'Update', SYSDATE);
END;
</syntaxhighlight>

Now doing exactly the same update as the above example, however this time with a statement level trigger. <syntaxhighlight lang="sql">
UPDATE phone_book SET phone_number = '111-111-1111' WHERE last_name = 'Jones';
</syntaxhighlight>

{| class="wikitable"
|-
! Audit_History_ID !! Username !! Modification !! Edit_Date
|-
| 1 || HAUSCHBC || Update || 02-MAY-14
|}

The result shows that the trigger was only called once, even though the update did change two rows.