Getting Information on Triggers

The user_triggers view has information on your triggers. Some of the columns in user_triggers:

Column	Type	Description
TRIGGER_NAME	VARCHAR2(30)	Name of the trigger.
TRIGGER_TYPE	VARCHAR2(16)	Type of the trigger.
TRIGGERING_EVENT	VARCHAR2(227)	Event that causes the trigger to fire.
TABLE_OWNER	VARCHAR2(30)	table owners.
BASE_OBJECT_TYPE	VARCHAR2(16)	Type of the object referenced.
TABLE_NAME	VARCHAR2(30)	Name of the table referenced by the trigger.
COLUMN_NAME	VARCHAR2(4000)	Name of the column referenced by the trigger.
REFERENCING_NAMES	VARCHAR2(128)	Name of the old and new aliases.
WHEN_CLAUSE	VARCHAR2(4000)	Trigger condition
STATUS	VARCHAR2(8)	ENABLED or DISABLED
DESCRIPTION	VARCHAR2(4000)	Description of the trigger.
ACTION_TYPE	VARCHAR2(11)	Action type of the trigger (CALL or PL/SQL).
TRIGGER_BODY	LONG	Code contained in the trigger body.

The all_triggers has information on all the triggers you have access to.


SELECT trigger_name, trigger_type, triggering_event, 
       table_ownerbase_object_type, table_name, referencing_names, when_clause, status,
       description, action_type, trigger_body
FROM user_triggers
WHERE trigger_name = 'BEFORE_EMP_UPDATE';

Home »
Oracle »
PL/SQL »

Triggers: