Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Inserting a & into a table
In article <01bd5d44$0a54a280$c802030a_at_server>, Shawn A. Savela wrote:
> How do I insert a row into a table that has an embedded '&'
> character in it via sqlplus?
>
> I tried :
>
> insert into mytable (field1) values ('Rock & Hard Place');
>
> and it asks me to define 'Hard'. Any combination of &&
> or &&& or /&, etc fails (obviously, I can't find any
> documentation on this). Do I need to do a CHR(?) or
> something to that effect, or is there an escape character
> I can use?
>
Try :
insert into mytable (field1) values ('Rock' || '&' || 'Hard Place');
Udo Received on Wed Apr 01 1998 - 00:00:00 CST