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>