This content has been marked as final. Show 3 replies
SELECT table_name, column_name(Almost) correct... names are normally uppercase within the dictionary, so if you want to be sure you'll find the table name, it would be better using
WHERE column_name = '&column_name'
SELECT table_name, column_name FROM user_tab_cols WHERE column_name = upper('&column_name')
USER_TABLES shows you your own tables. If you want to see all the tables to which you have access you can use ALL_TABLES.
DBA_TABLES shows all the tables in the database.
Edited by: Paul M. on Sep 21, 2010 2:26 PM
Sorry, not USER_TABLES, ALL_TABLES and DBA_TABLES, but USER_TAB_COLS, ALL_TAB_COLS and DBA_TAB_COLS.