Re: Simple SQL+ question

"Persian Computing" <PersianComputing_at_my-deja.com> wrote in message news:8p33d0$5o2$1_at_beast.euro.net...
> 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

insert into MyTable values
('First Column',
'First Line of Second Column'||chr(10)||'Second Line of Second Column','Third Column');

-Matt Received on Thu Sep 21 2000 - 00:00:00 CEST