Re: use sqlplus to generate a new line

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1997/10/04
Message-ID: <34371444.3848@deere.com>#1/1

Your code works for me!

Maybe your terminal doesn't accept linefeeds but only carriage returns.

Stp alc wrote:
>
> Everyone,
>
> How to use sqlplus to generate a new line (carriage return)
> define cr='chr(10)'
> select 'aaaaaaaa'||&&cr||'bbbbbb;'
> from dual;
>
> I want to output like
>
> aaaaaaa
> bbbbbbb
>
> bbbbbb on a new line
>
> instead i got
>
> aaaaaaa?bbbbbbb
>
> any clue ?
>
> Thanks Ted Chyn

-- 
John P. Higgins      Voice:    (309)765-7868
Deere & Company      Fax:      (309)765-7800
John Deere Road      Internet: jh33378nospam_at_deere.com
Moline, IL 61265     Opinions: My Own

Received on Sat Oct 04 1997 - 00:00:00 CDT