Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQLplus skipping lines

SQLplus skipping lines

From: Alan Long <TICS28_at_waccvm.corp.mot.com>
Date: 1997/07/04
Message-ID: <TICS28-0407971017130001@tics28.sps.mot.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US