Re: report with sqlplus
Date: 1996/06/04
Message-ID: <4p23ot$cgk_at_news.aimnet.com>#1/1
G. Cristian Palma A. (gpalma_at_dcc.uchile.cl) wrote:
: Hi friends ...
:
: Well, my problem ...
:
: I wanna know if is possible to "protect" records in a report made with
: sqlplus. The idea is the following: I have the next query (is an example :)):
:
: set lin 80;
: set pagesize 5;
: column a format a80;
: column b format a80;
: select a, b
: from table;
:
: i.e., each record will return 2 lines ...
:
: My wish is that the final record "jump" completely to the next page, this
: is, that the output take the form:
[snip]
Did you try setting pagesize to 4?
I'm still not sure what you're trying to do. Are you trying to
add whitespace at the bottom?
How about using BTITLE ?
BTITLE SKIP 1 ?
set newpage 0 ?
Tony Damon Received on Tue Jun 04 1996 - 00:00:00 CEST