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

Query dba_triggers

   <source lang="sql">

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></source>