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 -> Inserting a & into a table

Inserting a & into a table

From: Shawn A. Savela <ssavela_at_winternet.com>
Date: 1998/04/01
Message-ID: <01bd5d44$0a54a280$c802030a@server>#1/1

There has *got* to be an easy solution to this:

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?

Any help would be greatly appreciated...

-SS Received on Wed Apr 01 1998 - 00:00:00 CST

Original text of this message

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