Re: Get a short text for a search reasult inn CLOB field

This sounds like the "gist" feature of interMedia. When you discover that row X matches the search criteria, Oracle will stick a brief summary of the CLOB into a separate table from which you can retrieve it.

John

On 24 Oct 2001 01:43:25 -0700, r.moldovan_at_level7.ro (MOLDOVAN Radu Adrian) wrote:

>Hi,
>
>I'm using intermedia.
>I have a table titled
>test[
> ID - PK
> CONTENT -CLOB ]
>
>
>I want to search for a word in field CONTENT and as result I want to get
>a phrase or some words instead of entire CLOB info.
>
>How can I do that?
>
>Thanx

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/