Oracle 视图 ALL_INTERNAL_TRIGGERS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle的ALL_INTERNAL_TRIGGERS视图提供了对用户在其Schema下对象定义的内部触发器的相关信息，用于定义和改变数据库对象在特定事件发生时执行的操作。
例如，ALL_INTERNAL_TRIGGERS会提供如下信息：触发器名称，所属对象，发生的事件，触发条件，触发器代码等。
可以通过SELECT语句从ALL_INTERNAL_TRIGGERS视图中检索信息，如：
SELECT * FROM ALL_INTERNAL_TRIGGERS WHERE OWNER = ‘JOE_SCHEMA’;
这将显示Joe Schema下的所有触发器信息。
官方英文解释
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.
Related Views
-
DBA_INTERNAL_TRIGGERSdescribes internal triggers on all tables in the database. -
USER_INTERNAL_TRIGGERSdescribes all internal triggers on tables owned by the current user. This view does not display theOWNER_NAMEcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the table on which the trigger is defined |
|
|
|
|
Indicates the type of internal trigger on the table |
See Also:
-
“DBA_INTERNAL_TRIGGERS”
-
“USER_INTERNAL_TRIGGERS”
