[Home] [Help]
View: HR_TRIGGER_STATUS_V
View Text
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
FROM ALL_TRIGGERS
WHERE OWNER = 'APPS'
AND TABLE_OWNER = 'HR'
Columns
| Name |
| 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 |