如何创建对oracle数据库视图的注释 [英] How to create a comment to an oracle database view

问题描述

我真的很想为视图创建评论，并简要说明其目的.不幸的是，无法在oracle中创建对视图的注释.此功能仅适用于可用的表，列和实例化视图.我想知道您如何描述数据库视图?

I would really like to create a comment to a view with a short description of its purpose. Unfortunately it is not possible to create comments to views in oracle. This feature is only for tables, columns and materialized views available. I would like to know how you do describe your database views?

推荐答案

尝试:

comment on table <name> is 'text';

该命令适用于视图.例如:

The command works on views. For example:

CREATE OR REPLACE VIEW MY_VW AS
  SELECT 1 FROM DUAL;

COMMENT ON TABLE MY_VW IS 'Clever comment.';

这篇关于如何创建对oracle数据库视图的注释的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！