-
all_tab_comments
Can someone tell me how all_tab_comments selects records?
I login to sql*plus and do a "select * from all_tables where name = 'LOCATION' and I get the table. I can do a describe, etc on it with no problem.
When I do a "select * from all_tab_comments where name = 'LOCATION'" I get no results.
The problem is that the tool that I am using uses the a query against all_tab_comments to display tables and my tables are not showing up.
Any help would be appreciated!
Frank
-
Code:
SQL> SELECT COMMENTS FROM all_tab_comments WHERE TABLE_NAME='A';
COMMENTS
--------------------------------------------------------------------------------
SQL> comment on table a is 'This is a table';
Comment created.
SQL> SELECT COMMENTS FROM all_tab_comments WHERE TABLE_NAME='A';
COMMENTS
--------------------------------------------------------------------------------
This is a table
There may not be any comments. Add comments and still not coming post the outputs without editing.
-
I enforce users document there tables with comments so it is easier to work out what the tables are used for, then I monitor the objects created in case they don't follow the procedure