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

From: if_investor_at_yahoo.com <basis_consultant_at_hotmail.com>
Date: Tue, 23 Feb 2010 06:38:40 -0800 (PST)
Message-ID: <160ad947-8ab4-4a7d-bec2-ed2225dddf9b_at_f8g2000vba.googlegroups.com>

On Feb 22, 6:14 pm, joel garry <joel-ga..._at_home.com> wrote:
> 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
>
> Seehttp://asktom.oracle.com/pls/asktom/f?p=100:11:3980172595068555::::P1...
>
> jg
> --
> _at_home.com is bogus.http://jimhillmedia.com/blogs/jim_hill/archive/2010/02/09/what-happen...- Hide quoted text -
>
> - Show quoted text -

Hi,

Thanks to those who replied. I will check the AskTom script. This is not a class assignment; I am trying to find references to the server name in the database. Received on Tue Feb 23 2010 - 08:38:40 CST