Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DRG-50901 and escape characters
<vitalisman_at_gmail.com> a écrit dans le message de news:
1190378534.164506.97730_at_d55g2000hsg.googlegroups.com...
On Sep 21, 12:34 pm, "neo" <nelsounet_NO_SP..._at_free.fr_NO_SPAM> wrote:
> Hi everyone,
>
> I would like to make this work and I don't understand why it throws an
> DRG-50901 error ( wildcard query expansion resulted in too many terms )
>
> The select is this one :
>
> SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting\(%)' ) > 0)
>
> The goal is to search "something)*"
>
> the "\" should escape the ")" only..
>
> SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting%)' ) > 0)
> works fine
> and
>
> SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting\(' ) > 0)
> works too.
>
> Then What is wrong and how to make this working ?
>
> Thank you for your answer !
Are those the actual input you were testing? The lonesome right parenthesis in examples 1 and 2 look suspicious.
I'm sorry there's ")" which shouldn't be here. You may read :
1st One :
SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting\(%' ) > 0)
2nd One :
SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting%' ) > 0)
3rd One :
SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting\(' ) > 0)
Received on Fri Sep 21 2007 - 07:52:53 CDT