how to: oracle full text search over multiple columns

From: joes <joes_at_bluewin.ch>
Date: 24 Dec 2003 14:45:47 -0800
Message-ID: <26760a3e.0312241445.7bf7be55@posting.google.com>

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 Received on Wed Dec 24 2003 - 16:45:47 CST