Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: turning off escape character in oracle
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
![]() |
![]() |