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!