Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Escape character problems
in sql*plus
set def off
then try again
good luck to u!
<sfcq2_at_my-deja.com> wrote in message news:94v8mb$8db$1_at_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 Sun Jan 28 2001 - 08:13:13 CST