DBA_TRIGGERS

obclient[SYS]> SELECT * FROM SYS.DBA_TRIGGERS\G

*************************** 1. row ***************************
            OWNER: SYS
     TRIGGER_NAME: TRG_BEFORE_UPDATE
     TRIGGER_TYPE: BEFORE EACH ROW
 TRIGGERING_EVENT: UPDATE
      TABLE_OWNER: SYS
 BASE_OBJECT_TYPE: TABLE
       TABLE_NAME: TEST_TABLE
      COLUMN_NAME: NULL
REFERENCING_NAMES: REFERENCING NEW AS NEW OLD AS OLD
      WHEN_CLAUSE: NULL
           STATUS: ENABLED
      DESCRIPTION: NULL
      ACTION_TYPE: PL/SQL
     TRIGGER_BODY: TRIGGER trg_before_update
BEFORE UPDATE ON test_table
FOR EACH ROW
BEGIN
    :NEW.update_time := SYSTIMESTAMP;
    DBMS_OUTPUT.PUT_LINE('Trigger trg_before_update executed');
END
     CROSSEDITION: NO
 BEFORE_STATEMENT: NO
       BEFORE_ROW: YES
        AFTER_ROW: NO
  AFTER_STATEMENT: NO
   INSTEAD_OF_ROW: NO
        FIRE_ONCE: YES
APPLY_SERVER_ONLY: NO
*************************** 2. row ***************************
            OWNER: SYS
     TRIGGER_NAME: TRG_AUDIT_BASE
     TRIGGER_TYPE: AFTER EACH ROW
 TRIGGERING_EVENT: UPDATE
      TABLE_OWNER: SYS
 BASE_OBJECT_TYPE: TABLE
       TABLE_NAME: TEST_ORDER
      COLUMN_NAME: NULL
REFERENCING_NAMES: REFERENCING NEW AS NEW OLD AS OLD
      WHEN_CLAUSE: NULL
           STATUS: ENABLED
      DESCRIPTION: NULL
      ACTION_TYPE: PL/SQL
     TRIGGER_BODY: TRIGGER trg_audit_base
AFTER UPDATE ON test_order
FOR EACH ROW
BEGIN
    INSERT INTO audit_log(action_type, log_content, log_time)
    VALUES ('UPDATE', 'Base audit triggered', SYSTIMESTAMP);
END
     CROSSEDITION: NO
 BEFORE_STATEMENT: NO
       BEFORE_ROW: NO
        AFTER_ROW: YES
  AFTER_STATEMENT: NO
   INSTEAD_OF_ROW: NO
        FIRE_ONCE: YES
APPLY_SERVER_ONLY: NO
*************************** 3. row ***************************
            OWNER: SYS
     TRIGGER_NAME: TRG_AUDIT_DETAIL
     TRIGGER_TYPE: AFTER EACH ROW
 TRIGGERING_EVENT: UPDATE
      TABLE_OWNER: SYS
 BASE_OBJECT_TYPE: TABLE
       TABLE_NAME: TEST_ORDER
      COLUMN_NAME: NULL
REFERENCING_NAMES: REFERENCING NEW AS NEW OLD AS OLD
      WHEN_CLAUSE: NULL
           STATUS: ENABLED
      DESCRIPTION: NULL
      ACTION_TYPE: PL/SQL
     TRIGGER_BODY: TRIGGER trg_audit_detail
AFTER UPDATE ON test_order
FOR EACH ROW
FOLLOWS trg_audit_base
BEGIN
    INSERT INTO audit_log(action_type, log_content, log_time)
    VALUES ('UPDATE', 'Detail: Amount changed from ' || :OLD.amount || ' to ' || :NEW.amount, SYSTIMESTAMP);
END
     CROSSEDITION: NO
 BEFORE_STATEMENT: NO
       BEFORE_ROW: NO
        AFTER_ROW: YES
  AFTER_STATEMENT: NO
   INSTEAD_OF_ROW: NO
        FIRE_ONCE: YES
APPLY_SERVER_ONLY: NO
3 rows in set