本站中文解释

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	VARCHAR2(128)	NOT NULL	Owner of the user-defined operator
OPERATOR_NAME	VARCHAR2(128)	NOT NULL	Name of the user-defined operator
COMMENTS	VARCHAR2(4000)		Comment for the user-defined operator

See Also:

• “DBA_OPERATOR_COMMENTS”

• “USER_OPERATOR_COMMENTS”

---

编辑：一起学习网

标签：操作,类型,自定义,视图,注释