Oracle 视图 ALL_TRIGGERS_AE 官方解释,作用,如何使用详细说明
本站中文解释
ALL_TRIGGERS_AE视图用于显示在当前用户或其它用户中已编译的Autonomous Transaction Processing(ATP)和传统数据库中的触发器,包括触发器的完整详细信息(trigger_type, triggering_event, table_owner,base_object_type,table_name, Table_type)。
使用ALL_TRIGGER_AE视图时,可以轻松地查询和管理当前用户或其他用户的触发器,以查看相应的详细信息:
–查询当前用户中所有表的管理触发器。
SELECT *
FROM ALL_TRIGGERS_AE
WHERE trigger_type = ‘MANAGE’
AND base_object_type = ‘TABLE’;
–查询所有用户中表的管理触发器。
SELECT U.username, T.*
FROM all_users U, all_triggers_ae T
WHERE T.trigger_type = ‘MANAGE’
AND T.base_object_type = ‘TABLE’
AND U.username = T.table_owner;
官方英文解释
ALL_TRIGGERS_AE
describes the triggers on tables (across all editions) accessible to the current user.
If the user has the CREATE ANY TRIGGER
privilege, then this view describes all triggers (across all editions) in the database.
Related Views
-
DBA_TRIGGERS_AE
describes all triggers (across all editions) in the database. -
USER_TRIGGERS_AE
describes the triggers (across all editions) owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Owner of the trigger |
|
|
|
Name of the trigger |
|
|
|
When the trigger fires:
|
|
|
|
DML, DDL, or database event that fires the trigger See Also: Oracle Database PL/SQL |
|
|
|
Owner of the table on which the trigger is defined |
|
|
|
Base object on which the trigger is defined:
|
|
|
|
If the base object type of the trigger is |
|
|
|
Name of the nested table column (if a nested table trigger), else NULL |
|
|
|
Names used for referencing |
|
|
|
Must evaluate to |
|
|
|
Indicates whether the trigger is enabled ( |
|
|
|
Trigger description; useful for re-creating a trigger creation statement |
|
|
|
Action type of the trigger body:
|
|
|
|
Statements executed by the trigger when it fires |
|
|
|
Type of crossedition trigger:
|
|
|
|
Indicates whether the trigger has a |
|
|
|
Indicates whether the trigger has a |
|
|
|
Indicates whether the trigger has an |
|
|
|
Indicates whether the trigger has an |
|
|
|
Indicates whether the trigger has an |
|
|
|
Indicates whether the trigger will fire only for user processes making changes ( |
|
|
|
Indicates whether the trigger will only fire for a Replication Apply or SQL Apply process ( See Also: the |
|
|
|
Name of the application edition where the trigger is defined |
See Also:
-
“DBA_TRIGGERS_AE”
-
“USER_TRIGGERS_AE”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_DDL.SET_TRIGGER_FIRING_PROPERTY
procedure