Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Silly little sqlplus question :)
grz02 wrote:
> Now, my problem is that the output file will have a blank line
> before each row of output, i.e:
Actually is a linefeed between result sets - thus a linefeed after each command submitted by SQL*Plus to Oracle.
One way around it is to UNION ALL the separate SELECT statements - but that may not be possible (different projections cannot be unioned).
If there is a SQL*Plus command that allows this linefeed to be dynamically enabled and disabled, I would like to know too.
-- BillyReceived on Fri Jul 08 2005 - 07:56:54 CDT
![]() |
![]() |