Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>