Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql

Status
Not open for further replies.

powerbuilder

Programmer
Jan 15, 2001
2
SG
hi,

i need a result like from query,
first i need 5 records and again if click then next 5 records should display. is it possible thru sql * pls itself?

jeya
 
You must set pagesize to 5(number of records you need) + 1(page footer)+2(page header) and set pause on. So you'll get prompt for displaying each page.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top