DPS

• Oct 25th, 2011

 

info about triggers...like status of the triggers (enabled/disabled),trigger name,object name etc

ANIL

• Dec 13th, 2011

 

ABOUT TRIGGERNAME,
OWNER,
TRIGGERTYPE,
TRIGGEREVENT,
TABLEOWNER EXC
information is stored in DBA_TRIGGERS.

Rahul Gupta

• Aug 8th, 2016

 

OWNER
TRIGGER_NAME
TRIGGER_TYPE
TRIGGERING_EVENT
TABLE_OWNER
BASE_OBJECT_TYPE
TABLE_NAME
COLUMN_NAME
REFERENCING_NAMES
WHEN_CLAUSE
STATUS
DESCRIPTION
ACTION_TYPE
TRIGGER_BODY
CROSSEDITION
BEFORE_STATEMENT
BEFORE_ROW
AFTER_ROW
AFTER_STATEMENT
INSTEAD_OF_ROW
FIRE_ONCE
APPLY_SERVER_ONLY