COMMENT ON TABLE
303567Jan 7 2003 — edited Jan 7 2003Hi 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.