Finding specific data in Oracle Tables

[MURALI KRISHNA]

i have a schema with nearly 342 tables

now as my project requirement i want to replace specific data like "airtel" to "idea" in all scheme(342) tables

generally some tables contain columns like "description" these columns generally contain the value"airtel" in every record

can anyone provide a script which displays all tables and corresponding table columns contain that data "airtel"

thanks in advance..

 

[Roeland]

Tools-> Find Database Objects

 

[MURALI KRISHNA]

thank you for your valuable time and ,
I had visited the path what you mentioned but i think that search is only to search database objects.

i login into the scott/tiger@orcl data base
i was trying to search ename column it was successfull

but my requirement is to search the column value like ename column value "KING"

i entered column value "king" in "test to find" in Tools-> Find Database Objects

but i didn't get any result..

 

[roman65]

try thishttp://stackoverflow.com/questions/...lds-in-all-tables-for-a-specific-value-oracle