Re: SQL/plus question

Mark Webb wrote:
>
> Hi everyone,
>
> This must be a FAQ but I can't see how (if indeed it is
> possible) to get an ampersand (&) into a character literal
> in sql/plus.
>
> Something like:
>
> Insert into xxx values ('Me & you');
>
> Gives:
>
> please enter value for 'you':
>
> Thanks in advance.
>
> Mark W.

Use "set scan off" or "set scan <char>"

(Yes, it is documented)

Chrysalis Received on Fri Apr 11 1997 - 00:00:00 CDT