Re: Oracle Text Index and wildcards
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 4 Feb 2004 14:24:16 -0000
Message-ID: <40210091$0$7060$ed9e5944_at_reading.news.pipex.net>
Date: Wed, 4 Feb 2004 14:24:16 -0000
Message-ID: <40210091$0$7060$ed9e5944_at_reading.news.pipex.net>
It is at least 1999 since I looked at this, but I *believe* the answer is to use bind variables.
-- Niall Litchfield Oracle DBA Audit Commission UK "mtg" <pgervais_at_mtg.de> wrote in message news:bvqt49$2k9e$1_at_ulysses.news.tiscali.de...Received on Wed Feb 04 2004 - 15:24:16 CET
> Hi,
>
> how can I search for '%' and '_' in an Oracle Text
> Index. I tried with escape characters \ and {} but
> I always get all records of the table
>
> example :
>
> SELECT DISTINCT(login)
> FROM account
> WHERE CONTAINS( index_column1, '( %\%% ) WITHIN name')>0
>
> I also tried to define the % and the _ character as
> a printjoin, but also without any effect.
>
> Any idea ?
>
> Peter
>
>
>
>