Re: turning off escape character in oracle

veranoperu_at_yahoo.com (veranoperu) wrote in message news:<d7c10aa.0401131802.20dfa851_at_posting.google.com>...
> 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?
>
> Thanks,
> Britany Meza :-*

Obviously: Use the extra backslash. Who cares about typing one extra character?
The only other alternative is to use the ESCAPE clause of the SELECT statement everywhere. That would require typing 9 extra characters ;-)

Sybrand Bakker
Senior Oracle DBA Received on Wed Jan 14 2004 - 02:56:05 CST