Re: formfeed in SQL*PLUS ?

From: Chris Hamilton <chrish_at_cmprime.att.com>
Date: 1997/04/10
Message-ID: <01bc45f6$080ef2c0$2d89b687@chrish-pc.cis.att.com>#1/1

Steve Main <smain_at_cnw.com> wrote . . .

> I am creating a series of reports in sql*plus, I take the report output
 and
> 'cat' the files together and send the one file on to the printer. I
 would
> like to be able to insert a formfeed at the end of the queries so each
> report starts on a new page. I haven't had much luck in finding a way to
> do this. any ideas ?

Use the SQL*Plus command "set newpage 0" (zero, not O) to force a formfeed before each query.

Chris

---

Chris Hamilton -- chrish_at_cmprime.att.com DBA, AT&T WorldNet Service - Lincroft, NJ http://www.serve.com/cowpb/chamilton.html Received on Thu Apr 10 1997 - 00:00:00 CDT