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

Hallo Michael!

Under SQL*Plus your have to change the define-parameter: SQL> show all
...
define &
...

SQL> set define #
SQL> insert into test_table values ('abc&def');
SQL> commit;
SQL> set define &

Hope this help's,
Stefan.

Michael Maretzke <michael.maretzke_at_conrad.com> schrieb in im Newsbeitrag: 39be45a3$0$65_at_personalnews.de.uu.net...
> 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.
>
>
Received on Tue Sep 12 2000 - 12:56:07 CDT