Re: report with sqlplus

In article <4ovuou$92j_at_anakena.dcc.uchile.cl> gpalma_at_dcc.uchile.cl (G. Cristian Palma A.) writes:

> 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

You could use a union combined with a sort and a break:

  break on dummy skip page;
  column dummy noprint;

  select substr(a,2,2) dummy, a from table   union
  select substr(b,2,2) dummy, b from table   order by 1;

Adjust the substr() function to suit your data.

Hope this helps.

..dave

-- 

  +----------------------+----------------------------------------------+
  | David Rackley        | email: drack_at_tri.sbc.com                     |
  | Southwestern Bell    |   tel: (512) 372-5516  FAX: (512) 372-5591   |
  | Technology Resources |  http://www.tri.sbc.com/                     |
  | 9505 Arboretum Blvd  +----------------------------------------------+
  | Austin, TX 78759     | It's OK to be a martyr, as long as you don't |
  |                      | bring your own firewood.  -- Dr. Jim Rigby   |
  +----------------------+----------------------------------------------+