DBA Data[Home] [Help]

VIEW: SYS.CDB_TRIGGERS

Source

View Text - Preformatted

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","CROSSEDITION","BEFORE_STATEMENT","BEFORE_ROW","AFTER_ROW","AFTER_STATEMENT","INSTEAD_OF_ROW","FIRE_ONCE","APPLY_SERVER_ONLY","CON_ID" FROM CONTAINERS("SYS"."DBA_TRIGGERS")
View Text - HTML Formatted

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"
, "CROSSEDITION"
, "BEFORE_STATEMENT"
, "BEFORE_ROW"
, "AFTER_ROW"
, "AFTER_STATEMENT"
, "INSTEAD_OF_ROW"
, "FIRE_ONCE"
, "APPLY_SERVER_ONLY"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_TRIGGERS")