Re: Ways to Generate References to Specific Character String in a Schema
Date: Mon, 22 Feb 2010 14:06:23 -0800 (PST)
On Feb 22, 4:38 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> 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
> 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
A bunch of dynamic SQL in a PLSQL procedure could get this done for you ...
It kinda/sorta sounds an awful lot like a homework assignment for some class to me.
Maybe a CURSOR loop thru USER_TABLES might be a starting point ... Received on Mon Feb 22 2010 - 16:06:23 CST