Re: how to enter '&' in oracle table

If you are in sql*plus, try
set define #
before you do your insert.
[Quoted] (You may need to pick a different character than #, and you may need to set [Quoted] the define character back to & after you're done.)

<dksharma_at_my-deja.com> wrote in message news:8fh5st$1uk$1_at_nnrp1.deja.com...
> i want to enter '&' and a part of my varchar2 field value. oracle
> consider it as if i m passing parameter through it. help me how to enter
> a fileld value containg '&'
>
> regards
>
> d k sharma
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri May 12 2000 - 00:00:00 CEST