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