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

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 (ä) 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
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)