Simple SQL+ question
From: Persian Computing <PersianComputing_at_my-deja.com>
Date: Tue, 5 Sep 2000 17:27:42 +0200
Message-ID: <8p33d0$5o2$1_at_beast.euro.net>
Date: Tue, 5 Sep 2000 17:27:42 +0200
Message-ID: <8p33d0$5o2$1_at_beast.euro.net>
[Quoted] Hi there,
I have a simple question with regard to use the NewLine code in a SQL Plus script as follows:
insert into MyTable values ('First Column','First Line of Second Column\nSecond Line of Second Column','Third Column');
I guess this doesn't work since SQL Plus is not aware of \n as NewLine character!
Can someone explain how NewLine code can be added to the SQLPlus scripts?
BTW: I even used: SET Esc \ before my Insert command but it didn't help!
Thanks in advance,
N. Silakhori
Received on Tue Sep 05 2000 - 17:27:42 CEST