Re: Need to search for data in any Field

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 23 Feb 2002 01:50:49 GMT
Message-ID: <Xns91BE1CFAE5FFDgnuegischgnueg@130.133.1.4>

>> 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? 

>
>
> Try this one (CUSTOMERS needs to be in your schema. If not, use
> all_tab_columns instead of user_tab_columns)
>
>
>
> ---------->8--------->8--------->8--------------------
>
> set feedback off
> set pagesize 0
> drop table customers;

I mean, don't drop table customers if you have such a table; I used this line to test the script....

Rene

-- 
Recherchen im schweizerischen Handelsregister: 
http://www.adp-gmbh.ch/SwissCompanies/Search.php3

Received on Fri Feb 22 2002 - 19:50:49 CST