How to use all_col_comments and user_col_comments in Oracle11g?

Question

I have used the following statement to add the comment:

comment on column employee.first_name is 'first name of the employee table';

No I have difficulty in knowing how to use all_col_comments and user_col_comments to view the above comment using select statement.

I get the result if for all the tables when I use the query "select * from user_col_comments". However I want to retrieve the output only for employee table. — Pradeep Joshi, Mar 29 '15 at 06:46
Hi, have you come across the `WHERE` clause before? You can restrict this to `where table_name = 'EMPLOYEE'`. I would highly recommend doing some basic online tutorials first... — Ben, Mar 29 '15 at 08:11

score 2 · Answer 1 · answered Mar 29 '15 at 08:12

2

Simply use the table_name in the filter predicate.

For example,

select * from all_col_comments where table_name = 'EMPLOYEE';

The view has four columns:

Read more about the view in documentation.

answered Mar 29 '15 at 08:12

Lalit Kumar B

1 Answers1