| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Seeking a substring indexing package (or something)
This is a multi-part message in MIME format.
--------------0154EE7656FC4ED46B7C08F1
Content-Type: multipart/alternative; boundary="------------D5A91D852FC916246917D090"
--------------D5A91D852FC916246917D090 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Kevin Bourrillion wrote:
> I have a few tables with LONG and/or VARCHAR2(1000+) columns where > large > quantities of text are stored. People need to search this information > > using queries of the form: > > SELECT * FROM table > WHERE (column LIKE '%string1%' > OR column LIKE '%string2%') > AND column LIKE '%string3%')
You should check out Oracle Context Option.
OCO allows you to have queries of the form
SELECT...
FROM...
WHERE (column CONTAINS 'string1'
AND various other SQL conditions)
-- ------------------------------------------------------------------------------- Building the future of business to business electronic commerce... ------------------------------------------------------------------------------- ASM eTrade - Software from the Asian Sources Media Group ------------------------------------------------------------------------------- 24/F Vita Tower, Block B Tel: +852 2814 5678 29 Wong Chuk Hang Road Direct: +852 2814 5671 Aberdeen, Hong Kong Fax: +852 2311 3893 ------------------------------------------------------------------------------- --------------D5A91D852FC916246917D090 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bitReceived on Fri Aug 01 1997 - 00:00:00 CDT
<HTML>
<TT>Kevin Bourrillion wrote:</TT>
<BLOCKQUOTE TYPE=CITE><TT>I have a few tables with LONG and/or VARCHAR2(1000+)
columns where large</TT>
<BR><TT>quantities of text are stored. People need to search this
information</TT>
<BR><TT>using queries of the form:</TT>
<P><TT>SELECT * FROM table</TT>
<BR><TT>WHERE (column LIKE '%string1%'</TT>
<BR><TT> OR column LIKE '%string2%')</TT>
<BR><TT> AND column LIKE '%string3%')</TT></BLOCKQUOTE>
<TT>You should check out Oracle Context Option.</TT>
<P><TT>OCO allows you to have queries of the form</TT>
<P><TT>SELECT...</TT>
<BR><TT>FROM...</TT>
<BR><TT>WHERE (column CONTAINS 'string1'</TT>
<BR><TT> AND various other SQL conditions)</TT>
<BR>
<BR>
<BR>
<P><TT>--</TT>
<BR><TT>-------------------------------------------------------------------------------</TT>
<BR><TT>Building the future of business to business electronic commerce...</TT>
<BR><TT>-------------------------------------------------------------------------------</TT>
<BR><TT>ASM eTrade - Software from the Asian Sources Media Group</TT>
<BR><TT>-------------------------------------------------------------------------------</TT>
<BR><TT>24/F Vita Tower, Block B
Tel: +852 2814 5678</TT>
<BR><TT>29 Wong Chuk Hang Road
Direct: +852 2814 5671</TT>
<BR><TT>Aberdeen, Hong Kong
Fax: +852 2311 3893</TT>
<BR><TT>-------------------------------------------------------------------------------</TT>
<BR><TT> </TT></HTML>
--------------D5A91D852FC916246917D090-- --------------0154EE7656FC4ED46B7C08F1 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Michael Friedman Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Michael Friedman n: Friedman;Michael org: Asian Sources Media Group (eTrade) email;internet: mfriedma_at_asiansources.com x-mozilla-cpt: ;0 x-mozilla-html: FALSE end: vcard --------------0154EE7656FC4ED46B7C08F1--
 |
 |