Keyword: TRIGGER
jump to Columns back to indexTables
Table Name | Description |
---|---|
ALL_INTERNAL_TRIGGERS | Description of the internal triggers on the tables accessible to the user |
ALL_TRIGGERS | Triggers accessible to the current user |
ALL_TRIGGER_COLS | Column usage in user's triggers or in triggers on user's tables |
DBA_INTERNAL_TRIGGERS | Description of the internal triggers on all tables in the database |
DBA_TRIGGERS | All triggers in the database |
DBA_TRIGGER_COLS | Column usage in all triggers |
USER_INTERNAL_TRIGGERS | Description of the internal triggers on the user's own tables |
USER_TRIGGERS | Triggers owned by the user |
USER_TRIGGER_COLS | Column usage in user's triggers |
Columns
Column Name | Description |
---|---|
INTERNAL_TRIGGER_TYPE (ALL_INTERNAL_TRIGGERS) | Type of internal trigger |
INTERNAL_TRIGGER_TYPE (USER_INTERNAL_TRIGGERS) | Type of internal trigger |
INTERNAL_TRIGGER_TYPE (DBA_INTERNAL_TRIGGERS) | Type of internal trigger |
LOG_TRIGGER (ALL_SNAPSHOT_LOGS) | An after-row trigger on the master which inserts rows into the log |
LOG_TRIGGER (ALL_MVIEW_LOGS) | An after-row trigger on the master which inserts rows into the log |
LOG_TRIGGER (USER_SNAPSHOT_LOGS) | Trigger on master table; fills the snapshot log |
LOG_TRIGGER (DBA_MVIEW_LOGS) | An after-row trigger on the master which inserts rows into the log |
LOG_TRIGGER (USER_MVIEW_LOGS) | Trigger on master table; fills the materialized view log |
LOG_TRIGGER (DBA_SNAPSHOT_LOGS) | An after-row trigger on the master which inserts rows into the log |
NO_TRIGGER_MISMATCH (V$SQL_SHARED_CURSOR) | |
NO_TRIGGER_MISMATCH (GV$SQL_SHARED_CURSOR) | |
REPLICATION_TRIGGER_EXISTS (DBA_REPOBJECT) | Internal replication trigger exists? |
REPLICATION_TRIGGER_EXISTS (USER_REPOBJECT) | Inline trigger flag exists? |
REPLICATION_TRIGGER_EXISTS (ALL_REPOBJECT) | Internal replication trigger exists? |
TRIGGER_BODY (DBA_TRIGGERS) | Action taken by this trigger when it fires |
TRIGGER_BODY (ALL_TRIGGERS) | Action taken by this trigger when it fires |
TRIGGER_BODY (USER_TRIGGERS) | Action taken by this trigger when it fires |
TRIGGER_NAME (USER_TRIGGERS) | Name of the trigger |
TRIGGER_NAME (DBA_TRIGGER_COLS) | Name of the trigger |
TRIGGER_NAME (ALL_TRIGGERS) | Name of the trigger |
TRIGGER_NAME (ALL_TRIGGER_COLS) | Name of the trigger |
TRIGGER_NAME (USER_TRIGGER_COLS) | Name of the trigger |
TRIGGER_NAME (DBA_TRIGGERS) | Name of the trigger |
TRIGGER_OWNER (ALL_TRIGGER_COLS) | Owner of the trigger |
TRIGGER_OWNER (USER_TRIGGER_COLS) | Owner of the trigger |
TRIGGER_OWNER (DBA_TRIGGER_COLS) | Owner of the trigger |
TRIGGER_TYPE (USER_TRIGGERS) | Type of the trigger (when it fires) - BEFORE/AFTER and STATEMENT/ROW |
TRIGGER_TYPE (DBA_TRIGGERS) | When the trigger fires - BEFORE/AFTER and STATEMENT/ROW |
TRIGGER_TYPE (ALL_TRIGGERS) | When the trigger fires - BEFORE/AFTER and STATEMENT/ROW |