Page break in PL/SQL

Question

In PL/SQL program i have used

set pagesize 40;

so according to the above line the page break happens after 40 lines.

How do I increment a variable when the page break happens. i.e. i have a variable l_page_number and I should increment the l_page_number by 1 whenever page break happens. How to acheieve that??

plz help me out...

Answer 1

pagesize is a SQL*Plus command. In SQL*Plus we can show the page number (which I presume is what you really want) using SQL.PNO

The SQL*Plus documentation is online. You can find out more about formatting here.