Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> an 'ALL_FIELDS' equivalent

an 'ALL_FIELDS' equivalent

From: Kal Khatib <kal_at_gene.COM>
Date: 1998/02/13
Message-ID: <34E49AE6.5DFC2450@gene.com>#1/1

I don't know if it is possible, but..
I'm trying to translate this psuode statement into SQL

select * from table_1
where (any of the fields selected) like ('%somestring%')

OR

select f1,f2,f3,f4,f5,f6 from table_1
where (any of the fields selected ) like ...etc

is it possible to translate the 'any of the fields selected' to SQL?

thanks for any help
Kal.

--
http://members.tripod.com/~kalk
Received on Fri Feb 13 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US