Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba triggers

Query dba_triggers

SQL>
SQL> SELECT owner, trigger_name, trigger_type,
  2         triggering_event, table_owner||"."||table_name
  3  FROM   dba_triggers
  4  WHERE  status <> "ENABLED"
  5  AND    owner  = "PLSQL_USER"
  6  and    rownum < 2
  7  ORDER BY owner, trigger_name;
no rows selected
SQL>
SQL>