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 the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the trigger

TRIGGER_NAME

VARCHAR2(128)

Name of the trigger

TRIGGER_TYPE

VARCHAR2(16)

When the trigger fires:

  • BEFORE STATEMENT

  • BEFORE EACH ROW

  • AFTER STATEMENT

  • AFTER EACH ROW

  • INSTEAD OF

  • COMPOUND

TRIGGERING_EVENT

VARCHAR2(246)

DML, DDL, or database event that fires the trigger

See Also: Oracle Database PL/SQL
Language Reference
for additional information about triggers and triggering events.

TABLE_OWNER

VARCHAR2(128)

Owner of the table on which the trigger is defined

BASE_OBJECT_TYPE

VARCHAR2(18)

Base object on which the trigger is defined:

  • TABLE

  • VIEW

  • SCHEMA

  • DATABASE

TABLE_NAME

VARCHAR2(128)

If the base object type of the trigger is SCHEMA or DATABASE, then this column is NULL; if the base object type of the trigger is TABLE or VIEW, then this column indicates the table or view name on which the trigger is defined

COLUMN_NAME

VARCHAR2(4000)

Name of the nested table column (if a nested table trigger), else NULL

REFERENCING_NAMES

VARCHAR2(422)

Names used for referencing OLD and NEW column values from within the trigger

WHEN_CLAUSE

VARCHAR2(4000)

Must evaluate to TRUE for TRIGGER_BODY to execute

STATUS

VARCHAR2(8)

Indicates whether the trigger is enabled (ENABLED) or disabled (DISABLED); a disabled trigger will not fire

DESCRIPTION

VARCHAR2(4000)

Trigger description; useful for re-creating a trigger creation statement

ACTION_TYPE

VARCHAR2(11)

Action type of the trigger body:

  • CALL

  • PL/SQL

TRIGGER_BODY

LONG

Statements executed by the trigger when it fires

CROSSEDITION

VARCHAR2(7)

Type of crossedition trigger:

  • FORWARD

  • REVERSE

  • NO

BEFORE_STATEMENT

VARCHAR2(3)

Indicates whether the trigger has a BEFORE STATEMENT section (YES) or not (NO)

BEFORE_ROW

VARCHAR2(3)

Indicates whether the trigger has a BEFORE EACH ROW section (YES) or not (NO)

AFTER_ROW

VARCHAR2(3)

Indicates whether the trigger has an AFTER EACH ROW section (YES) or not (NO)

AFTER_STATEMENT

VARCHAR2(3)

Indicates whether the trigger has an AFTER STATEMENT section (YES) or not (NO)

INSTEAD_OF_ROW

VARCHAR2(3)

Indicates whether the trigger has an INSTEAD OF section (YES) or not (NO)

FIRE_ONCE

VARCHAR2(3)

Indicates whether the trigger will fire only for user processes making changes (YES) or whether the trigger will also fire for Replication Apply or SQL Apply processes (NO)

APPLY_SERVER_ONLY

VARCHAR2(3)

Indicates whether the trigger will only fire for a Replication Apply or SQL Apply process (YES) or not (NO). If set to YES, then the setting of FIRE_ONCE does not matter.

See Also: the DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY procedure

EDITION_NAME

VARCHAR2(128)

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 the DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY procedure


数据运维技术 » Oracle 视图 ALL_TRIGGERS_AE 官方解释,作用,如何使用详细说明