From: "Franck HUGOT" <fhugot@globalimmo.org>
Subject: Complex search for a String
Date: 2000/08/08
Message-ID: <8momkm$i6i$1@reader1.imaginet.fr>#1/1
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@imaginet.fr
X-Trace: reader1.imaginet.fr 965729750 18642 213.41.15.149 (8 Aug 2000 10:15:50 GMT)
Organization: ImagiNET / Colt Internet
X-MSMail-Priority: Normal
NNTP-Posting-Date: 8 Aug 2000 10:15:50 GMT
Newsgroups: comp.databases.oracle.misc


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.