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 |