开发者

Page break in PL/SQL

In PL/SQL program i have used

set pagesize 40;

so according to the above line the page break happens afte开发者_如何学编程r 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...


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜