Oracle 视图 USER_TRIGGER_ORDERING 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图:USER_TRIGGER_ORDERING
用途:该视图是系统视图,用于查询用户创建的触发器的宣告顺序。该视图用于查看定义了多个触发器的顺序,以及每个触发器被触发的执行顺序。
使用方法:可以通过如下语句查询USER_TRIGGER_ORDERING视图:
SELECT * FROM USER_TRIGGER_ORDERING WHERE TRIGGER_NAME = ”;
官方英文解释
USER_TRIGGER_ORDERING
describes the triggers owned by the current user that have FOLLOWS
or PRECEDES
ordering. Its columns (except for TRIGGER_OWNER
) are the same as those in ALL_TRIGGER_ORDERING
.
See Also:
“ALL_TRIGGER_ORDERING”