Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL/plus question

Re: SQL/plus question

From: Dora Kilburn <dora_at_chsra.wisc.edu>
Date: 1997/04/11
Message-ID: <334E4EBD.5ED1@chsra.wisc.edu>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US