INSERTing string containing character '&'

From: Howard Lee Harkness <hl_harkness_at_my-dejanews.com>
Date: Sat, 15 May 1999 21:51:44 GMT
Message-ID: <7hkq9f$kfv$1@nnrp1.deja.com>

I have a table defined as:
CREATE TABLE NAMES
(

MFGCODE VARCHAR2(5),
MFGNAME VARCHAR2(40)
);

I tried to do an insert similar to the following:

INSERT INTO NAMES
( '00001', 'Bartles&James' );

and SQL*Plus responded with:

Enter value for James:

Which is a good indicator that the '&' is some sort of special character, presumably used for passing parameters interactively. So how do I defeat the special nature of this character? Are there other characters I need to defeat? I have about 7 Mb of names in a file to import, many of which contain '&' in the name.

--
Replies send to this email address are automatically discarded. To reply, please post in this newsgroup, or send to harkness at skeptics dot org. Thank-you.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Sat May 15 1999 - 16:51:44 CDT