Re: Inserting text including &

From: Erwin jasinski <hexalog_at_wanadoo.fr>
Date: Sun, 4 Jul 1999 10:35:47 +0200
Message-ID: <7ln6ka$es2$1@wanadoo.fr>

Bonjour,
Hello,

&& don't work but chr(38) work

insert into table_name values ('word1 '||chr(38)||' word2');

Erwin

Khal a écrit dans le message ...
>Hello there,
>I need some help inserting a text field that includes an &.
>
>example:
>
>insert into table_name values ('word1 & word2');
>
>This would cause sqlplus to prompt me for the value of word2.
>
>anyway to solve that problem.
>Thanks a million in advance.
>
>Khal
>
>
Received on Sun Jul 04 1999 - 03:35:47 CDT