Re: page count in SQL*PLUS report

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 16 Jan 2003 00:24:40 GMT
Message-ID: <cZmV9.1335$aN1.67004644@newssvr15.news.prodigy.com>

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. Received on Wed Jan 15 2003 - 18:24:40 CST