insert of spesial characters

From: (wrong string) ål BergersenAdekvat C AS <pal.bergersen_at_hm.telia.no>
Date: 1997/10/11
Message-ID: <01bcd62b$30fe4800$4be6ccc3_at_adekvat>#1/1


Asume table A
(
A varchar2(80)
)

[Quoted] [Quoted] 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 Sat Oct 11 1997 - 00:00:00 CEST

Original text of this message