Re: Fulltextsearch How to do

Bernd wrote:

> Hallo,
>
> I have to migrate an MS-SQL-Server DB to Oracle 8.X. I have only a problem
> with the fulltextsearch in MS-SQL.
> In MS-SQL the use an SQL-Statment like "select * from table where FREETEXT
> (field,'searchtext')".
>
> Is there also an way like this for Oracle. Does anybody have an example ?
>
> Regards Bernd

you can use CLOB structure description in table

after index this CLOB text column

and use apropriate search SQL in this structure same as multi column

--
Henri Irla

             Syscom Ingénierie
Chemin du Mas de l'Arbre - 66350 - Toulouges - France

     Tel (33)- 468545078 - Fax (33)- 468545464 Email : info_at_syscom-ing.com / henri_at_titan.syscom-ing.com

           http: www.syscom-ing.com Received on Sat Dec 04 1999 - 00:15:51 CST