Oracle教程 2023-03-20

Oracle 视图 ALL_TRIGGER_ORDERING 官方解释，作用，如何使用详细说明

ALL_TRIGGER_ORDERING 视图用于查询指定的表是否具有触发器，或其触发器在指定的表中的顺序。它显示可用的信息如表名，触发器类型，触发器顺序，触发器名称等。

使用这个视图，你可以查询特定表（例如，EMP）下是否有触发器以及如果有，则这些触发器的名字和类型以及顺序：

SELECT *
FROM all_triggers_ordering
WHERE table_name = ‘EMP’;

ALL_TRIGGER_ORDERING describes the triggers accessible to the current user that have FOLLOWS or PRECEDES ordering.

Related Views

DBA_TRIGGER_ORDERING describes all triggers in the database that have FOLLOWS or PRECEDES ordering.
USER_TRIGGER_ORDERING describes the triggers owned by the current user that have FOLLOWS or PRECEDES ordering. This view does not display the TRIGGER_OWNER column.

Column	Datatype	NULL	Description
`TRIGGER_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the trigger
`TRIGGER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the trigger
`REFERENCED_TRIGGER_OWNER`	`VARCHAR2(128)`		Owner of the referenced trigger
`REFERENCED_TRIGGER_NAME`	`VARCHAR2(128)`		Name of the referenced trigger
`ORDERING_TYPE`	`VARCHAR2(8)`		Type of the ordering between the trigger and the referenced trigger: `FOLLOWS` `PRECEDES`