Oracle 视图 ALL_OPERATOR_COMMENTS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图ALL_OPERATOR_COMMENTS显示包括评论的操作类型。这些操作类型包括存储过程、函数和触发器。它还可以用来取出用户自定义的操作类型以及其它自定义内容。
使用ALL_OPERATOR_COMMENTS视图,可以检索用户定义的操作类型的注释:
SELECT OBJECT_TYPE, OBJECT_NAME, COMMENTS
FROM ALL_OPERATOR_COMMENTS
WHERE OBJECT_TYPE IN (‘PROCEDURE’, ‘FUNCTION’, ‘TRIGGER’);
如果需要添加某个操作的注释,可以使用COMMENT命令:
COMMENT ON PROCEDURE my_proc IS ‘T his procedure does something complicated’;
官方英文解释
ALL_OPERATOR_COMMENTS
displays comments for the user-defined operators accessible to the current user.
Related Views
-
DBA_OPERATOR_COMMENTS
displays comments for all user-defined operators in the database. -
USER_OPERATOR_COMMENTS
displays comments for the user-defined operators owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the user-defined operator |
|
|
|
Name of the user-defined operator |
|
|
Comment for the user-defined operator |
See Also:
-
“DBA_OPERATOR_COMMENTS”
-
“USER_OPERATOR_COMMENTS”