Donn wrote: > this question seems to be unrelated to perl but merely sql.
that's right. you'd probably be better off posting to a more appropriate forum. this page has several for oracle: http://www.faqs.org/faqs/databases/oracle-faq/ > can somebody pls. help me with sql on how > to page the resultset from a select query... > say page 1 contains first 1-100 rows, page 2 is 101-200 rows...and so on. > > i need to make a page toolbar with links to each page > in a resultset similar to this: > > <FIRST><NEXT> 1 2 3 4 5 6 7 8 9 <PREVIOUS><LAST> my oracle is a little rusty, but in postgresql i'd use something like: select * from foo limit 100 offset 0 and that will select the 1st 100 records, then you just adjust the 'offset' to get previous or next group of records. if you can't do that in oracle then you'll probably have to create a cursor. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
