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 -> Re: A difficult SQL Query, MARY and FRED

Re: A difficult SQL Query, MARY and FRED

From: DStevens <dstevens_at_navidec.com>
Date: Fri, 15 Mar 2002 12:33:41 -0700
Message-ID: <a6tiai$924$1@newsreader.mailgate.org>


Maybe I'm missing something?

Select keyword, unorderedstring from tblkeywords a, tblToBeSearched b WHERE unorderedstring
LIKE '%' || keyword || '%';

KEYWORD UNORDEREDSTRING

-------------------- ----------------------------------------
FRED                 PETER AND FRED WENT DOWN TO THE
                     PUB

MARY                 NO ***MARY*** DF\K\\
Received on Fri Mar 15 2002 - 13:33:41 CST

Original text of this message

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