Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple SQL+ question
Use the chr()-function.
insert into MyTable values ('First Column','First Line of Second Column' || CHR(13) || 'Second Line of Second Column','Third Column');
Stefan.
Persian Computing <PersianComputing_at_my-deja.com> schrieb in im Newsbeitrag:
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
>
>
>
>
Received on Tue Sep 05 2000 - 11:12:03 CDT