Simple SQL+ question

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 - 10:27:42 CDT