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
>
>
>
>

This is a SQL issue, not a SQL*Plus issue. It should work using the chr(10), so '<any string>||chr(10)||'< rest of any string>').
In your next post, could you please refrain from posting to all Oracle newsgroups?

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Sep 05 2000 - 10:49:48 CDT