Escape character problems

From: <sfcq2_at_my-deja.com>
Date: Sat, 27 Jan 2001 19:48:29 GMT
Message-ID: <94v8mb$8db$1@nnrp1.deja.com>

Hello,

I am trying to add some data to a table which involves the naming of different species of plants.

One of the fields in my "insert" command is the following:

"(Pomel)Quezel & Santa"

The full insert command being:

insert into synonyms_tbl values ('Vicia sativa subsp. nigra', 'Vicia', 'NULL', 'sativa', 'NULL', 'subsp.', 'consobrina', '"(Pomel)Quezel & Santa"', 'NULL', 'NULL', 'NULL');

Unfortunately, Oracle picks up on the "&" symbol and asks me to enter a key for Santa!

How can I nullify the "&" symbol so that Oracle just enters it as a normal character?

I'm using Oracle 8.

Thanks for any help you can offer,

Rob.

Sent via Deja.com
http://www.deja.com/ Received on Sat Jan 27 2001 - 13:48:29 CST