Re: page count in SQL*PLUS report

From: Frank <fvanbortel_at_netscape.net>
Date: Sun, 19 Jan 2003 21:29:55 +0100
Message-ID: <3E2B0AC3.8060201@netscape.net>

Karsten Farrell wrote:
> Ming wrote:
>

>> Hi, all:
>> How can I put something like 'Page 1 of xx' on SQLPLUS report?  Thanks.
>> Ming

>
> ttitle ... right 'Page ' format 999 sql.pno
>
> But you probably already knew that. It's the "of xx" that you can't
> easily do in sqlplus (it doesn't know in advance how many pages will be
> generated).
>
> Of course, you could guestimate it by using a COLUMN...NOPRINT statement
> combined with SELECT COUNT(*)/rows_per_page_plus_header_plus_footer...
> kind of thing.
>

One thing that could be done using RPT/RPF... Good old days... ivory towers and all that... :-?

Frank Received on Sun Jan 19 2003 - 14:29:55 CST