Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> an 'ALL_FIELDS' equivalent
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/~kalkReceived on Fri Feb 13 1998 - 00:00:00 CST