Re: Escape character problems

Hey, it worked!

Thanks alot,

Rob.

In article <bJVc6.69775$9D3.3224094_at_news.hananet.net>,   "Lee Kyoung Rok" <tunnel_at_hananet.net> wrote:
> 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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Sun Jan 28 2001 - 08:53:45 CST