Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL/plus question
Mark Webb wrote:
> 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':
Try:
SET ESCAPE '\'
Insert into xxx values ('Me \& you');
Dora
-- News posting tip of the day: Have your subject line be the actual SUBJECT of your message, not "HELP, HELP, HELP ME PLEASE I NEED HELP!!!"Received on Fri Apr 11 1997 - 00:00:00 CDT
![]() |
![]() |