Oracle: view triggers on a table 

Joined:
04/09/2007
Posts:
770

September 13, 2008 20:23:18    Last update: September 13, 2008 20:41:05
Oracle provides three views to view triggers on tables:
  1. USER_TRIGGERS describes the triggers owned by the current user. This view does not display the OWNER column.
  2. ALL_TRIGGERS describes the triggers on tables accessible to the current user.
  3. DBA_TRIGGERS describes all triggers in the database.


These are the columns:

Column NameDescription
OWNEROwner of the trigger
TRIGGER_NAMEName of the trigger
TRIGGER_TYPEWhen the trigger fires: BEFORE/AFTER and STATEMENT/ROW, INSTEAD OF, COMPOUND
TRIGGERING_EVENTDML, DDL, or database event that fires the trigger
TABLE_OWNEROwner of the table on which the trigger is defined
BASE_OBJECT_TYPEBase object on which the trigger is defined: TABLE, VIEW, SCHEMA, DATABASE
TABLE_NAMEName of the table that this trigger is associated with, NULL if BASE_OBJECT_TYPE is SCHEMA or DATABASE
COLUMN_NAMEName of the nested table column (if a nested table trigger), else NULL
REFERENCING_NAMESNames used for referencing OLD and NEW column values from within the trigger
WHEN_CLAUSEMust evaluate to TRUE for TRIGGER_BODY to execute
STATUSENABLED or DISABLED, trigger will not fire if DISABLED
DESCRIPTIONTrigger description
ACTION_TYPEAction type of the trigger body: CALL or PL/SQL
TRIGGER_BODYStatements executed by the trigger when it fires
Share |
| Comment  | Tags