CODEWITHSUNDEEP
oracle-databaseviewcomments
Tony Wolff
Tony Wolff

Reputation: 742

Adding comment to a column of a view in oracle

Clearly it is possible to add a comment to describe a view, but is it possible to add a comment to describe an individual column of a view in oracle?

Upvotes: 2

Views: 13570

Answers (1)

are
are

Reputation: 2615

see comment on column

Use the COMMENT statement to add a comment about a table, view, materialized view, or column into the data dictionary.

example

create table tst_delete (col1 int); 

create view v_tst_delete as select * from tst_delete;

check in SQLPlus 

SQL> comment on column v_tst_delete.col1 is 'is my view column comment';

Comment added
SQL> desc v_tst_delete
Name Type    Nullable Default Comments                  
---- ------- -------- ------- ------------------------- 
COL1 INTEGER Y                is my view column comment 

SQL>

Upvotes: 4

Related Questions