Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Text Problem with special characters

Re: Oracle Text Problem with special characters

From: Peter Gervais <pgervais_at_mtg.de>
Date: Tue, 03 Feb 2004 13:41:25 +0100
Message-ID: <bvo4tl$1vdp$1@ulysses.news.tiscali.de> 





Jan Gelbrich schrieb:


...


> So what about

> WHERE CONTAINS( index_column1, '( %'||Chr(38)||'% ) ')>0

> 

> hth, Jan




I tried ( and many other combinations ) but i only got : ORA-00933 SQL 
command not properly ended.



If I try something like :


WHERE CONTAINS( index_column1, '( %S\&F% ) ')>0



everything works fine. I only got all records if I'am
just looking for %\&%.
Received on Tue Feb 03 2004 - 06:41:25 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US