Find The Trigger

Return to site

Find The Trigger

ColumnDatatypeNULLDescription
OWNERVARCHAR2(30)Owner of the trigger
TRIGGER_NAMEVARCHAR2(30)Name of the trigger
TRIGGER_TYPEVARCHAR2(16)When the trigger fires: BEFORE STATEMENT, BEFORE EACH ROW, BEFORE EVENT, AFTER STATEMENT, AFTER EACH ROW, and AFTER EVENT
TRIGGERING_EVENTVARCHAR2(227)The DML, DDL, or database event that fires the trigger. For a listing of triggering events, see the CREATE TRIGGER statement in Oracle Database SQL Reference.
TABLE_OWNERVARCHAR2(30)Owner of the table on which the trigger is defined
BASE_OBJECT_TYPEVARCHAR2(16)Base object on which the trigger is defined: TABLE, VIEW, SCHEMA, or DATABASE
TABLE_NAMEVARCHAR2(30)If the base object type of the trigger is SCHEMA or DATABASE, then this column is NULL; if the base object type of the trigger is TABLE or VIEW, this columns indicates the table/view name on which the trigger is defined
COLUMN_NAMEVARCHAR2(4000)Name of the nested table column (if nested table trigger), else null
REFERENCING_NAMESVARCHAR2(128)Names used for referencing OLD and NEW column values from within the trigger
WHEN_CLAUSEVARCHAR2(4000)Must evaluate to TRUE for TRIGGER_BODY to execute
STATUSVARCHAR2(8)Indicates whether the trigger is enabled (ENABLED) or disabled (DISABLED)
DESCRIPTIONVARCHAR2(4000)Trigger description; useful for re-creating a trigger creation statement
ACTION_TYPEVARCHAR2(11)Action type of the trigger body (CALL or PL/SQL)
TRIGGER_BODYLONGStatements executed by the trigger when it fires
Find The Trigger FingerOct 24, 2014 You have to dig in the GUI to find triggers on tables and views Well, that's where things get interesting. You can use the GUI in SSMS, but you have to dig through the tables & views to find the triggers. They aren't in the same locations as stored procedures or functions. By all means, LA was actually perfectly happy with the original cast not being in Grisaia: Phantom Trigger the Animation, as it's a new generation of characters at the helm of what the original cast once did and seeing the Grisaia world being expanded upon after the original cast left is a good thing, cos like come on, Yuuji and the rest of the. Myofascial trigger point reference including referred pain and muscle diagrams as well as symptoms caused by triggerpoints.
Find The Trigger Of The First

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	Owner of the trigger
`TRIGGER_NAME`	`VARCHAR2(30)`	Name of the trigger
`TRIGGER_TYPE`	`VARCHAR2(16)`	When the trigger fires: `BEFORE STATEMENT`, `BEFORE EACH ROW`, `BEFORE EVENT`, `AFTER STATEMEN`T, `AFTER EACH ROW`, and `AFTER EVENT`
`TRIGGERING_EVENT`	`VARCHAR2(227)`	The DML, DDL, or database event that fires the trigger. For a listing of triggering events, see the `CREATE TRIGGER` statement in Oracle Database SQL Reference.
`TABLE_OWNER`	`VARCHAR2(30)`	Owner of the table on which the trigger is defined
`BASE_OBJECT_TYPE`	`VARCHAR2(16)`	Base object on which the trigger is defined: `TABLE, VIEW`, `SCHEMA`, or `DATABASE`
`TABLE_NAME`	`VARCHAR2(30)`	If the base object type of the trigger is `SCHEMA` or `DATABASE`, then this column is `NULL`; if the base object type of the trigger is `TABLE` or `VIEW`, this columns indicates the table/view name on which the trigger is defined
`COLUMN_NAME`	`VARCHAR2(4000)`	Name of the nested table column (if nested table trigger), else null
`REFERENCING_NAMES`	`VARCHAR2(128)`	Names used for referencing `OLD` and `NEW` column values from within the trigger
`WHEN_CLAUSE`	`VARCHAR2(4000)`	Must evaluate to `TRUE` for `TRIGGER_BODY` to execute
`STATUS`	`VARCHAR2(8)`	Indicates whether the trigger is enabled (`ENABLED`) or disabled (`DISABLED`)
`DESCRIPTION`	`VARCHAR2(4000)`	Trigger description; useful for re-creating a trigger creation statement
`ACTION_TYPE`	`VARCHAR2(11)`	Action type of the trigger body (`CALL` or `PL/SQL`)
`TRIGGER_BODY`	`LONG`	Statements executed by the trigger when it fires

Find The Trigger Of Null