Oracle TRIGGER
Check TRIGGER DDL
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;
Database Event Types
Database Event Types
AFTER STARTUP
BEFORE SHUTDOWN
AFTER DB_ROLE_CHANGE
AFTER SERVERERROR
AFTER LOGON
BEFORE LOGOFF
AFTER SUSPEND
AFTER CLONE
BEFORE UNPLUG
BEFORE SET CONTAINER
AFTER SET CONTAINER
Useful Data Dictionary Views
Useful Data Dictionary Views
DBA_TRIGGERS
Bibliography
Bibliography
https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/CREATE-TRIGGER-statement.htmlhttps://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/ALTER-TRIGGER-statement.htmlhttps://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/DROP-TRIGGER-statement.htmlhttps://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-triggers.html
https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_metada.htmhttps://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_metada.htm#BGBIEDIAhttps://oracle-base.com/articles/9i/dbms_metadata
https://stackoverflow.com/questions/536516/how-to-develop-an-after-serverror-trigger-in-oracle
https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_metada.htmhttps://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_metada.htm#BGBIEDIAhttps://oracle-base.com/articles/9i/dbms_metadata
https://stackoverflow.com/questions/536516/how-to-develop-an-after-serverror-trigger-in-oracle