Re: SQL*Plus

From: L. Carl Pedersen <l.carl.pedersen_at_dartmouth.edu>
Date: Tue, 13 Sep 1994 09:33:43 -0500
Message-ID: <l.carl.pedersen-1309940933430001_at_kip-sn-126.dartmouth.edu>

In article <354694$r0i_at_mule.fhcrc.org>, steved_at_orca.fhcrc.org (Steve Dahlberg) wrote:

> Using SQL*PLUS, is there an easy way to include page
> numbers on a report when the report consists of a
> series of several SQL querries. I'm able to get
> page numbers for the first SQL querrie but it resets
> itself to page 1 on the subsequent ones. thanks

this may sound brutish, but could you glue the queries together using UNION? in ORACLE 7 use UNION ALL. In 6 you need to be careful about duplicate rows getting dropped. Received on Tue Sep 13 1994 - 16:33:43 CEST

This message: [ Message body ]
Next message: Krishnan Vaidyanathan: "Re: Question on proC"
In reply to Steve Dahlberg: "SQL*Plus"
Next in thread: Christopher Jones: "Re: SQL*Plus"
Reply: Michael T. Turk: "Re: SQL*Plus"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message