From: Connor McDonald <connor_mcdonald@yahoo.com>
Subject: Re: Complex search for a String
Date: 2000/08/08
Message-ID: <398FFCF8.4828@yahoo.com>#1/1
Content-Transfer-Encoding: 7bit
References: <8momkm$i6i$1@reader1.imaginet.fr>
To: Franck HUGOT <fhugot@globalimmo.org>
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: newsabuse@remarq.com
X-Trace: 965762936 LGTBT6QCL22D2D501C uk21.supernews.com
Organization: RemarQ http://www.remarQ.com
Mime-Version: 1.0
Reply-To: connor_mcdonald@yahoo.com
Newsgroups: comp.databases.oracle.misc


Franck HUGOT wrote:
> 
> Hello,
> 
> I would like to search a String in all columns of a table.
> I know I can do :
> select user_name from usertable where user_prenom='smith' or
> user_ville='smith' or user_alias='smith' or ....
> 
> Is there a more simple way?
> 
> Thanks in advance.

where instr(col1||col2||col3||... , 'string') > 0

HTH
-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse