Debu Das wrote:
> "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
Search on "Oracle Text" with a search engine and especially at
otn.oracle.com ... and learn about the DBMS_LOB built-in package too.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Mar 22 2004 - 10:32:52 CST
