Re: Searching in complete DB
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Mon, 14 Jul 2003 09:43:30 +0200
Message-ID: <1058168544.28025_at_news.thyssen.com>
Date: Mon, 14 Jul 2003 09:43:30 +0200
Message-ID: <1058168544.28025_at_news.thyssen.com>
"qazmlp" <qazmlp1209_at_rediffmail.com> schrieb im Newsbeitrag
news:db9bbf31.0307100947.247d2db4_at_posting.google.com...
> 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)?
A little addition to what Daniel wrote:
limit your search to the columns
with a length >= 'YourString'.
Will reduce the ugly work a bit.
hth,
Guido
Received on Mon Jul 14 2003 - 09:43:30 CEST