Re: Searching CLOBS case insensitive

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Mon, 19 May 2003 22:08:16 +0400
Message-ID: <bab6ku$7c2$1@babylon.agtel.net>

"Petri" <member29878_at_dbforums.com> wrote in message news:2897023.1053357406_at_dbforums.com...
>
> Is this type of index available in 8i or only 9i?
>

Yes, CTXSYS.CONTEXT index type is available on 8i. Each new release usually adds some new functionality and support for quite a few new document formats (if you store documents in various formats, like Word or WordPerfect, in BLOB columns) through newer INSO filters, plus usual bugfixes and minor internal tweaks, but basic capabilities are the same.

As I suggested earlier, refer to Oracle interMedia Text reference for more details on this feature (that's for 8i, in 9i it was renamed to Oracle Text.) You can find complete searchable docs here: http://tahiti.oracle.com

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.

Received on Mon May 19 2003 - 13:08:16 CDT