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 |