Query dba_triggers : dba_triggers « System Tables Data Dictionary « Oracle PL/SQL Tutorial






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>








30.45.dba_triggers
30.45.1.Query dba_triggers