OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » TTITLE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TTITLE [message #11037]

Tue, 02 March 2004 12:52

Ravi
Messages: 251
Registered: June 1998

Senior Member

How do I use the TTITLE command to display a Page X of TotalPage?

I know that the Page X can be displayed using "TTITLE RIGHT 'Page: ' FORMAT 999 SQL.PNO SKIP 1". How about TotalPage? Thanks!

Report message to a moderator

Re: TTITLE [message #11082 is a reply to message #11037]

Fri, 05 March 2004 01:04

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

This would only be possible if you know how many pages will be returned in advance. The problem is that sqlplus doesn't know either. Example:

DEFINE TotalPages=128

TTITLE RIGHT 'Page: ' FORMAT 999 SQL.PNO " from " FORMAT 999 TotatPages SKIP 1

Best regards.

Frank

Report message to a moderator

Previous Topic:	datafile recovering
Next Topic:	Faster Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:39:07 CDT 2024