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: Bricklen <Xbricklen_at_yahoo.comX>
Date: Mon, 12 Jan 2004 22:35:31 GMT
Message-ID: <TiFMb.72283$JQ1.40482@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) Received on Mon Jan 12 2004 - 16:35:31 CST

Original text of this message

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