Re: Ways to Generate References to Specific Character String in a Schema

From: joel garry <joel-garry_at_home.com>
Date: Mon, 22 Feb 2010 15:14:01 -0800 (PST)
Message-ID: <3cab0b49-b951-4187-a405-3017eb9637c0_at_g28g2000prb.googlegroups.com>

On Feb 22, 1:38 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> Hi,
>
> In a 10g database, I am looking for all ways to list references
> to a specific data string in any table of a specific schema, assuming
> that the fields are all VARCHAR2.
>
> For example, suppose that there is a schema named OLYMPICS.
>
> That schema has many tables, and I am looking for all tables that
> have a data value of 'Vancouver' (Hopefully, case insensitive), in
> any field. The fields are all VARCHAR2.
>
> So, the script will, hopefully, generate the following data. The most
> important
> info. is the tablename... I can live without the fieldname and value.
> I would
> prefer the case insensitivity, but I can live without that also.
>
> Schema       Table      Field                Data Value
>
> OLYMPICS- HOST     Currenthost      vancouver
> OLYMPICS- CITIES    2010host         Vancouver
>
> etc..
>
> Thanks,
> QZ

See
http://asktom.oracle.com/pls/asktom/f?p=100:11:3980172595068555::::P11_QUESTION_ID:37336026927381#tom37395410204420

jg

--
_at_home.com is bogus.
http://jimhillmedia.com/blogs/jim_hill/archive/2010/02/09/what-happens-when-things-actually-do-sort-of-kind-of-go-horribly-wrong-at-a-disney-theme-park.aspx

Received on Mon Feb 22 2010 - 17:14:01 CST