Re: Simple SQL+ question

AFAIK, you can include a newline character with a function call: 'First Line'||CHR(13)||'Second Line'

HTH as a netiquette note: it is considered (by many, including me) to cross post questions to all oracle newsgroups. as such, i am replying only to the .server newsgroup.

"Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message news:sslce2dhbsik0f_at_corp.supernews.com...
> "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 CDT