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

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

Re: Inserting text including &

From: Erwin jasinski <hexalog_at_wanadoo.fr>
Date: Sun, 4 Jul 1999 10:41:52 +0200
Message-ID: <7ln6vm$f26$1@wanadoo.fr>


Complement !

chr(38) give & for french code in the database You have to replace 38 by the good value for your database.

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:41:52 CDT

Original text of this message

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