Check TRIGGER DDL

You can extract the TRIGGER DDL using DBMS_METADATA...

SET LONG 100000

SELECT dbms_metadata.get_ddl('TRIGGER',UPPER('&MYTRGNAME'),UPPER('&MYSCHEMA')) AS job_definition_ddl

FROM dual;

Useful Data Dictionary Views

• DBA_TRIGGERS

Bibliography