Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> use sqlplus to generate a new line
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
![]() |
![]() |