| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> SQLplus skipping lines
I have a SQLplus query like:
spool test
select a, b, c, d
from z;
spool off
My output consists of many lines of data which are difficult to read since they stretch across a wide page, so I'd like to insert a skip line after each, say, 5 lines of output. I don't want to use PAGESIZE for this purpose since I want to print the output and I don't want ttitles every 5 lines. The data is such that I cannot break on any column.
Any ideas?
-- Alan Long Materials Systems Group Motorola, East Kilbride, Scotland email tics28_at_email.mot.comReceived on Fri Jul 04 1997 - 00:00:00 CDT
![]() |
![]() |