Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: special character
in SQL*PLUS
set def off
"Martin Haltmayer" <Martin.Haltmayer_at_0800-einwahl.de> wrote in message
news:3A62A048.1EDF50FD_at_0800-einwahl.de...
> Several methods:
>
> a) By bind variables (preferred)
> b) By changing the scan character to something different
> c) By switching the scanning off.
> d) By using the expression chr (38).
>
> b) and c) cannot be done sometimes (outside SQL*Plus). d) is cumbersome.
So
> stick with a).
>
> Martin
Received on Mon Jan 15 2001 - 09:16:10 CST