report with sqlplus

From: G. Cristian Palma A. <gpalma_at_dcc.uchile.cl>
Date: 1996/06/03
Message-ID: <4ovuou$92j_at_anakena.dcc.uchile.cl>#1/1


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:

A11
B11
A12
B12

A21
B21
A22
B22

etc.

and not:

A11
B11
A12
B12
A21

B21
A22
B22
A23
B23

etc.

Well, thanks for any help

"Saludos desde Chile"

Cristian

--

Pd: I tried with the sentence break on skip <xxx> but I haven't luck :) ...
Received on Mon Jun 03 1996 - 00:00:00 CEST

Original text of this message