Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLplus skipping lines
You could try one of two thing depending on which is best for your situation.
set heading off 2. select a, b, c, d||decode(mod(rownum, 5), 0, ' ', '') from z /
Note: With solution 2 the close single quote ' must be on a newline and there must be a space on the newline before the close quote. Also the characters before the close bracket ")" on the second line is two single quotes and not a double quote.
If you have any problems let me know.
Winston Douglas
wdouglas_at_cott.com
Alan Long <TICS28_at_waccvm.corp.mot.com> wrote in article
<TICS28-0407971017130001_at_tics28.sps.mot.com>...
> 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.com
>
Received on Fri Jul 04 1997 - 00:00:00 CDT