Oracle SQL: How do I find the table name given the column names? -

Oracle SQL: How do I find the table name given the column names? -

if know names of every column of table not name of table, how find name of table need?

try (one known column):

create table mytab(mycol varchar2(30 char));select table_name user_tab_columns column_name='mycol';

note mycol in upper case in column_name='mycol';

cheers!

sql oracle