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 11:23:07 -0800 (PST)
Message-ID: <45664098-8d7f-4571-ac3c-4f0b6d8254d8_at_b18g2000vbl.googlegroups.com>

On Feb 23, 12:37 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Feb 23, 6:38 am, "if_inves..._at_yahoo.com"
>
>
>
>
>
> <basis_consult..._at_hotmail.com> wrote:
> > 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...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.
>
> Don't know if this will work, it's just off the top of my head, but in
> the past I've searched export files like so, kinda slow:
>
> strings xyz.exp|awk '{ if (match($0,"CREATE TABLE")>0) {saveline=$0}
> {if (match($0,"Abcdefg")>0) {print saveline}}}'|sort -u|more
>
> It will miss it if the export breaks up the string Abcdefg, though, I
> can't remember if exp does that in column data.
>
> jg
> --
> _at_home.com is bogus.http://www.ibtimes.com/articles/20100223/developers-arms-over-apples-...- Hide quoted text -
>
> - Show quoted text -

Hi,

Thanks to all who replied. The AskTom script worked well.

QZ Received on Tue Feb 23 2010 - 13:23:07 CST