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

Home -> Community -> Usenet -> c.d.o.misc -> Re: turning off escape character in oracle

Re: turning off escape character in oracle

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 14 Jan 2004 09:23:37 GMT
Message-ID: <bu31qp$cjcft$1@ID-82536.news.uni-berlin.de>

> Bricklen <Xbricklen_at_yahoo.comX> wrote in message news:<TiFMb.72283$JQ1.40482_at_pd7tw1no>...

>> veranoperu wrote:
>> > Hi all,
>> > I'm running into an issue with the escape character '\' and string
>> > literals when using oracle. I don't want oracle to process this
>> > escape sequence. I know I can use an extra backslash character but
>> > that would be inconvenient. In sybase, for example, you can turn this
>> > off by "set option Escape_character = 'off'". Does anybody know of
>> > the method to do this in oracle.
>> >
>> > Thanks,
>> >
>> > Britany Meza
>> If you mean turn it off in SQL*Plus, then type:
>> set escape off
>> in the SQL*Plus window.
>> (or: set escape some_other_character)
> 
> Thanks for the help.  However, I am connecting to an Oracle DB via
> ODBC.  I tried executing 'set escape off' but that didn't work.  Any
> other ideas of how this might be accomplished?


Britany

set escape is an SQL*PLUS command and cannot be applied to ODBC.

Escaping metacharacters belongs to the basic set that a programmer must be aple to handle.

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch
Received on Wed Jan 14 2004 - 03:23:37 CST

Original text of this message

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