Search for tablename and column name for one value across 1 database

[daves1]

Hi,
I want to search for the table name and column name that have the value "ABC" .

Any idea with where i could start with this one?

thanks.

[Dave44]

yep, within each schema look in user_tables or user_tab_column s. Or join the two on tablename and look for what you need.

[debasisdas]

dictionary can provide you information regarding the structure of the objects not the containing data.

[AdusumalliGopikumar]

select * from user_tables where table_name like 'ABC%';

This Query will give you all the tables having ABC as it name

select * from user_tab_cols where column_name like 'ABC%';

This Query will listy all the columns having ABC in the column name