Re: how to: oracle full text search over multiple columns

From: Daniel Morgan <>
Date: Fri, 26 Dec 2003 11:38:58 -0800
Message-ID: <1072467445.101198_at_yasure>

joes wrote:

> Hello there
> I am looking for a way to realize a full text search on a whole table
> in oracle 8.1.7 . I found "catsearch()" and "contains()" features. But
> it seems that these only supports the lookup for a single column. So
> exists there way to realize a full text search over multiple columns ?
> How ?
> second Question I have is about, does Oracle supports an automatic
> translation of special characters suring the search ? for instance
> german "umlaute" so that the a umlaut (&auml;) is automatic trnsalted
> into 'ae' or 'a'. Or that the french characters are translated into
> 'e' ?
> thanks xou for any answers on this
> regards
> Mark

To do so in a relational database is meaningless. If you feel this is a capability you need ... then I'd suggest you find someone to teach you how to design a relational schema.

Daniel Morgan
(replace 'x' with a 'u' to reply)
Received on Fri Dec 26 2003 - 20:38:58 CET

Original text of this message