Re: Oracle Text question

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 14 Nov 2006 03:24:58 -0800
Message-ID: <1163503498.412454.110510@f16g2000cwb.googlegroups.com>

Jeremy wrote:
> Version: 9iR2
>
> When you doa search in e.g. google, it comes back with the document
> title and then a few words from the document with the keywords
> highlighted.
>
> Is this possible with Oracle Text in 9i?
>
> We have already defined text indexes and provide keyword searching tools
> but our result sets simply show the score returned by the contains
> clause.
>
> Appreciate any pointers on this?
>
>
> --
> jeremy
>
> ============================================================
> ENVIRONMENT:
> Oracle 9iR2 / Oracle HTTP Server / mod_plsql / Solaris 8
> ============================================================

Yes, it's possible to highlight search terms in the document. See the docs on CTX_DOC package in Text Reference, MARKUP and HIGHLIGHT procedures.

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Tue Nov 14 2006 - 05:24:58 CST