Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How do I Insert newlines between columns
I have an SQL statement as follows:
I would like to format the output so that it appears as follows:
columna
columnb
columnc
So, I need to concatenate the newline command. (\n) at the end of the
first two columns.
The problem is that if I just coincatenate the newline command, the
output I get is
just columna\n columnb\n columnc\n.
Does anyone know how I can achieve this?
Received on Wed May 26 1999 - 05:43:45 CDT
![]() |
![]() |