| 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 |