Re: Insert text including &
From: Graham Miller <lgmiller_at_elmrd.u-net.com>
Date: Sun, 04 Jul 1999 00:17:45 GMT
Message-ID: <377ea750.60265807_at_news.u-net.com>
Date: Sun, 04 Jul 1999 00:17:45 GMT
Message-ID: <377ea750.60265807_at_news.u-net.com>
On Sat, 3 Jul 1999 16:45:02 -0500, "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
>
Set scan off
or if you still want to use substition variables you need to pick a different character. lets use a '{' (left brace) Use the command
set scan {
graham Received on Sun Jul 04 1999 - 02:17:45 CEST