Re: How to insert a value like 'abc&def' into a varchar2

From: <sanrenkur_at_my-deja.com>
Date: Tue, 12 Sep 2000 17:13:03 GMT
Message-ID: <8plo68$u0v$1@nnrp1.deja.com>

In article <39be45a3$0$65_at_personalnews.de.uu.net>, "Michael Maretzke" <michael.maretzke_at_conrad.com> wrote:
> Hello, Oracle - Fans !
>
> I've got the silly problem of inserting a value like 'abc&def' into a
> varchar2-field.
> But ... Inserting this literal causes my SQL-Plus to ask for the
value of
> the
> variable "def" ...
>
> Is it possible to insert the original string ??
> And if - how ?
>
> Many thanx ...
>
> I'll read the f***ing manual meanwhile ...
>
> CU Michael.
>

Hi
Try setting SCAN OFF or define the substitution character as something else
HTH
Sanrenkur
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 12:13:03 CDT

Re: How to insert a value like 'abc&def' into a varchar2 - field ...