Re: how to reset the page number variable sql.pno

Looks like it is impossible to solve this problem in Oracle sqkplus. I Hope Oracle company can solve this problem in the new version.

lli_at_sos.state.tx.us (Laya Li) wrote in message news:<6fb217d.0303261336.18e58df4_at_posting.google.com>...
> Hi everyone,
> I have a report that is generated with SQL and SQLPlus commands. I
> use BREAK and COMPUTE commands. However when I start a new page for
> the new group by BREAK, I want the page number in the Title to start
> at 1 again.
>
> I have not found anyway to reset the page number variable (sql.pno)
> that I use in the Report Title.
>
> Does anyone know a way to do this or possibly suggest another
> solution?
>
> Thanks,
>
> Laya
Received on Mon Mar 31 2003 - 16:00:11 CEST