Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: searching entire database

Re: searching entire database

From: Anurag Varma <avoracle_at_gmail.com>
Date: 10 Feb 2007 05:54:39 -0800
Message-ID: <1171115679.603852.177910@p10g2000cwp.googlegroups.com>


On Feb 10, 5:55 am, Rene Nyffenegger <rene.nyffeneg..._at_gmx.ch> wrote:
> On 2007-02-10, seannakas..._at_yahoo.com <seannakas..._at_yahoo.com> wrote:
>
> > How do I search the entire database for a value and return the
> > tablenames and column names that contain this value? For argument
> > sake, let's say I'm searching for the text "the quick brown fox".
>
> > I think someone posted this question before but it never got any
> > responses--since it's been awhile, i thought i might post it again.
>
> > In case your wondering why I want to do this, I'm using a software
> > package that stores all it's data in a database. It shows me the
> > data, but I have no idea what tables and column names contain these
> > values so it's hard to change the data through sql scripting.
>
> I have written something that might be helpful for you on
> my website athttp://www.adp-gmbh.ch/ora/misc/find_in_tables.html
>
> hth,
> Rene
>
> --
> Rene Nyffenegger
> http://www.adp-gmbh.ch

Rene,

Nice code. I was wondering if it can be made faster by filtering out columns
whose data_length is smaller than the length of the string being searched.
One of course needs to be careful with char length semantics / utf8

Cheers
Anurag Received on Sat Feb 10 2007 - 07:54:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US