[Home] [Help] [Dependency Information]
Object Name: | DBA_TRIGGERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All triggers in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Owner of the trigger | |
TRIGGER_NAME | VARCHAR2 | (128) | Name of the trigger | |
TRIGGER_TYPE | VARCHAR2 | (16) | When the trigger fires - BEFORE/AFTER and STATEMENT/ROW | |
TRIGGERING_EVENT | VARCHAR2 | (246) | Statement that will fire the trigger - INSERT, UPDATE and/or DELETE | |
TABLE_OWNER | VARCHAR2 | (128) | Owner of the table that this trigger is associated with | |
BASE_OBJECT_TYPE | VARCHAR2 | (18) | ||
TABLE_NAME | VARCHAR2 | (128) | Name of the table that this trigger is associated with | |
COLUMN_NAME | VARCHAR2 | (4000) | The name of the column on which the trigger is defined over | |
REFERENCING_NAMES | VARCHAR2 | (422) | Names used for referencing to OLD and NEW values within the trigger | |
WHEN_CLAUSE | VARCHAR2 | (4000) | WHEN clause must evaluate to true in order for triggering body to execute | |
STATUS | VARCHAR2 | (8) | If DISABLED then trigger will not fire | |
DESCRIPTION | VARCHAR2 | (4000) | Trigger description, useful for re-creating trigger creation statement | |
ACTION_TYPE | VARCHAR2 | (11) | ||
TRIGGER_BODY | LONG | (0) | Action taken by this trigger when it fires | |
CROSSEDITION | VARCHAR2 | (7) | Type of crossedition trigger - FORWARD, REVERSE or NO | |
BEFORE_STATEMENT | VARCHAR2 | (3) | ||
BEFORE_ROW | VARCHAR2 | (3) | ||
AFTER_ROW | VARCHAR2 | (3) | ||
AFTER_STATEMENT | VARCHAR2 | (3) | ||
INSTEAD_OF_ROW | VARCHAR2 | (3) | ||
FIRE_ONCE | VARCHAR2 | (3) | If NO then the trigger will also fire in replication apply processes | |
APPLY_SERVER_ONLY | VARCHAR2 | (3) | If YES then the trigger will only fire in replication apply processes |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM SYS.DBA_TRIGGERS;
|
|
|