Searching in complete DB

#1

I want to search for a string in the values of all the columns of all
the accessible Tables. How do you do that in SQL(sqlplus)?

#2

On 10 Jul 2003 10:53:07 -0700, qazmlp1209 (AT) rediffmail (DOT) com (qazmlp)
wrote:

Quote:

I want to search for a string in the values of all the columns of all
the accessible Tables. How do you do that in SQL(sqlplus)?

You search google before posting this FAQ again.
You could of course also just grep the database files ;-)

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Searching in complete DB

comp.databases.oracle.server comp.databases.oracle.server

Searching in complete DB - 07-10-2003 , 12:53 PM

Re: Searching in complete DB - 07-10-2003 , 01:21 PM