Re: Full text search in oracle

"Douglas Hawthorne" <douglashawthorne_at_yahoo.com.au> wrote in message news:<3Cf6c.109575$Wa.105023_at_news-server.bigpond.net.au>...
> "Debu Das" <debu_at_rheal.com> wrote in message
> news:298f0e41.0403180236.638936fa_at_posting.google.com...
> > Hi Friends,
> >
> > Does Oracle have any Full text search functionality equivalent of SQL
> > server?
> > IF so, What components needs to be installed?
> > And How is the Full text search implemnted in Oracle? I meant to say
> > how to use it in the stored procedure?
> >
> > Any information provided will be greatly appreciated.
> >
> > Thanks in advance,
> >
> > Debu
>
> Debu,
>
> You may want to investigate Oracle Text in 9i and later (this was called
> interMedia Text in earlier versions). There are two (2) manuals available
> in 9i: a reference and application developer's guide. Ch. 17 of "Expert
> One-on-One Oracle" by Thomas Kyte (A-Press: 2003) focuses on interMedia
> text.
>
> Douglas Hawthorne

Hi Douglas,

I want to do a full text search on CLOB datatype rather than varchar, which has a file content(document) store in it. Could you provide me with more information about it?

Thanks,

Debu Received on Mon Mar 22 2004 - 06:49:45 CST