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.
Privileges may be required for certain queries.

Examples

  
SELECT * FROM USER_TRIGGERS ;

SELECT * FROM USER_TRIGGER_COLS;

SELECT * FROM USER_OBJECTS 
WHERE OBJECT_TYPE = 'TRIGGER';

SELECT * FROM USER_PROCEDURES W
HERE 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';