Re: Need to search for data in any Field

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Thu, 21 Feb 2002 21:22:15 GMT
Message-ID: <bydd8.7896$xs1.2542791@news1.news.adelphia.net>

The way I would do it is to

start sqlplus
describe table_name
copy the fields from there to a file editor remove the extraneous stuff

add "= 'Activated'  " to the end of each line
add "where " to the begining of the first line
add "or " to the begining of all the other lines
add "select * from  table_name" as the first line

now, copy all that into the clipboard, or save it to a file and go back to sqlplus and either paste the clipboard contents and type "/" and press enter or "start " the file.

"Pamela" <pameladc_at_hotmail.com> wrote in message news:f9f7dfd4.0202211256.4bc82e32_at_posting.google.com...
> I'm interested in looking for the work "Activated" in a table called
> Customers that has over 35 fields. What is the easies way to do this
> without having to use the each different field in a query?
Received on Thu Feb 21 2002 - 15:22:15 CST