How to create a comment on oracle database view

Question

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

Answer 1

Try:

comment on table <name> is 'text'; 

The team is working on presentations. For instance:

 CREATE OR REPLACE VIEW MY_VW AS SELECT 1 FROM DUAL; COMMENT ON TABLE MY_VW IS 'Clever comment.'; 

Answer 2

Commenting on VIEWs is possible:

 COMMENT ON TABLE view_name ; 

Answer 3

Just use:

 Comment on table 'view Name' is ' Comment ...'; 

If you use a view instead of SQL, Oracle will issue an invalid object category for the COMMENT command.

Materialized view: we can just comment using:

 Command on Materialized view "View name" is 'Comment ...';