List all triggers from Oracle database

How to list all triggers from Oracle database

To list all triggers from Oracle database you can query tables: USER_TRIGGERS, USER_TRIGGER_COLS, USER_OBJECTS, USER_PROCEDURES, ALL_PROCEDURES, DBA_PROCEDURES.

Examples

  
SELECT * FROM USER_TRIGGERS ;

SELECT * FROM USER_TRIGGER_COLS;

SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TRIGGER';

SELECT * FROM USER_PROCEDURES WHERE OBJECT_TYPE='TRIGGER';

SELECT * FROM ALL_PROCEDURES 
WHERE OBJECT_TYPE='TRIGGER' AND OWNER='SYSTEM';

SELECT * FROM DBA_PROCEDURES 
WHERE OBJECT_TYPE='TRIGGER' AND OWNER='SYSTEM';