Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Inserting text including &

Re: Inserting text including &

From: Suchart Tontapanish <ttontapa_at_us.oracle.com>
Date: Wed, 14 Jul 1999 16:49:07 -0400
Message-ID: <7mit5d$nj7$1@inet16.us.oracle.com>


Try this one

insert into table_name values (column, column) values ('word1', 'word2');

Khal wrote in 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 Wed Jul 14 1999 - 15:49:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US