Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

COMMENT ON TABLE

303567Jan 7 2003 — edited Jan 7 2003
Hi everyone.
I have issued the following statement

SQL> COMMENT ON TABLE employees IS
2 'Info. about employees of company';

Comment created.

Where are these comments stored in the data dictionary?

I tried to view USER_TABLES with the following stmt.

SQL> SELECT table_name, column_name, char_used
2 FROM user_tab_columns
3 WHERE table_name = 'employees';

no rows selected

I am in the scema HR that comes with Oracle 9i, and I couldn't understand the problem. But it shows the table employees when I selected the table_name from that view with the stmt.

SQL> edit
Wrote file afiedt.buf

1* select table_name from user_tab_columns

Can someone help me as soon as possible.

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2003
Added on Jan 7 2003
6 comments
240 views