Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
ALL_INTERNAL_TRIGGERS
describes internal triggers on tables accessible to the current user. Internal triggers are internal pieces of code executed when a particular flag is set for a table. This view does not display the OWNER_NAME
column.
DBA_INTERNAL_TRIGGERS
describes internal triggers on all tables in the database.
USER_INTERNAL_TRIGGERS
describes all internal triggers on tables owned by the current user. This view does not display the OWNER_NAME
column.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLE_NAME |
VARCHAR2(30) |
Name of the table on which the trigger is defined | |
OWNER_NAME |
VARCHAR2(30) |
Owner of the table | |
INTERNAL_TRIGGER_TYPE |
VARCHAR2(19) |
Indicates the type of internal trigger on the table |