Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> use sqlplus to generate a new line

use sqlplus to generate a new line

From: Stp alc <stpalc_at_aol.com>
Date: 1997/10/04
Message-ID: <19971004143700.KAA14744@ladder02.news.aol.com>#1/1

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 Received on Sat Oct 04 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US