Re: Inserting text including &

From: Xuening Sun <ba503_at_torfree.net>
Date: Tue, 6 Jul 1999 14:06:07 GMT
Message-ID: <FEGCI7.Kq1.0.bloor@torfree.net>

Khal,

You could try the following INSERT statement:

insert into table_name values ('word1 ' || '&' || ' word2');

Xuening Sun
--

Khal (elsawi_at_xsimple.com) wrote:
: 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 Tue Jul 06 1999 - 09:06:07 CDT