Re: search query

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 20 Dec 2001 05:51:18 -0800
Message-ID: <a8aed4.0112200551.32600f58@posting.google.com>

prateek_kakkar_at_hotmail.com (Prateek) wrote in message news:<d485b627.0112192219.5954c7a3_at_posting.google.com>...
> How is it possible to search for a value in the whole database.That is
> the details of all occurances of that value in whole database. For eg
> i have the following tables :
> 1) table1 -fields ( f1, f2, f3)
> 2) table2 -fields ( tf1,tf2,tf3)
>
> Now i have a value stored in f1 and the same value is stored in tf3
> field also. So by just passing that value how can i know both the
> table names and column name.
>
> monu

This may be helpful...

SEARCHING FOR SPECIFIC COLUMN VALUES | by Karen Porter

Ever needed to find a value within an Oracle table when you don't know what table or column_name holds the value? Here is some dynamic SQL used to accomplish this objective...

>> CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci787162,00.html

Regards,
Ganesh R Received on Thu Dec 20 2001 - 07:51:18 CST