Re: insert of spesial characters

From: Sunder Rajan <rajan_at_t-iii.com>
Date: 1997/10/15
Message-ID: <344537C8.B6D1F333_at_t-iii.com>#1/1


The Following Command works.

Insert into A Values ( 'Day ' || '&' || ' Night'); Commit;

Sunder Rajan.

  • Pål BergersenAdekvat C AS wrote:

>* Asume table A
>* (
>* A varchar2(80)
>* )
>*
>* I am trying to insert the string 'Day & Night' into table A.
>* Sql*plus prompts me for input on the &.
>*
>* I have tried with ' ' Day & Night' '.
>* This gives me 'Day and Night' in the database.
>* Thanks.
>*
>* pal.bergersen_at_hm.telia.no.spam
>*
>* Please cc to this adress without the .spam
>
* Received on Wed Oct 15 1997 - 00:00:00 CEST

Original text of this message