trigger

CREATE OR REPLACE TRIGGER demo_trigger
AFTER UPDATE ON debug_demo1
REFERENCING OLD AS "USER_BEFORE_UPDATED" NEW AS "USER_AFTER_UPDATED"
FOR EACH ROW
DECLARE  
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
    INSERT INTO debug_demo1
        VALUES
        ('ab',:USER_BEFORE_UPDATED.note, :USER_AFTER_UPDATED.id);
        commit;
END;