Path: utzoo!attcan!uunet!cs.utexas.edu!usc!sdd.hp.com!zaphod.mps.ohio-state.edu!rpi!uupsi!sunic!tut!funic!santra!santra!s32977p
From: s32977p@saha.hut.fi (Jaakko Wallenius)
Newsgroups: comp.databases
Subject: Re: Oracle SQL*Plus: How do I put page number on query?
Message-ID: <S32977P.90Jul18165044@saha.hut.fi>
Date: 18 Jul 90 14:50:44 GMT
References: <1990Jul17.173930.12616@ariel.unm.edu>
Sender: news@santra.uucp (Cnews - USENET news system)
Organization: Helsinki University of Technology, Finland
Lines: 22
In-Reply-To: drew@hydra.unm.edu's message of 17 Jul 90 17:39:30 GMT

In article <1990Jul17.173930.12616@ariel.unm.edu> drew@hydra.unm.edu (E Drew Einhorn ADV.SCI.Inc) writes:

>   Does anybody know the trick for getting oracle to put page numbers
>   in an customized query page header/footer.
>
>   The TTI[TLE] and BTI[TLE] commands have to forms.

I am currently working with Oracle for Macintosh and with it You can
get page numbers to header/footer with TTITLE/BTITLLE.

Here is an example:

TTITLE skip 3 center `Header text`  right `page: ` sql.pno skip 2

Where skips are used for inserting blank lines, `Header text` is
printed in the center of line and `page: ` with page number is printed
right justified.

Hope this helps !

Jaakko Wallenius
s32977p@saha.hut.fi