How can a rownum help in implementing Pagination

[Ravi Kiran Va]

Hi

How can we use rownum technique to implement pagination .

My query is that we use rownum to limit the the number of records given by database engine .

Where as the concept of Pagination involves to display results based on the click of the Hyper Link
(Similar to Google Search )

For example if i click on "4" Hyperlink i want to display data from 40th record to 50th record , how a rowmnum can help in this case ??

Please share your ideas .

Thanks in advance .

[Jaikiran Pai]

There's a journal article for this.

[Ravi Kiran Va]

the link is so helpful .

Thank you very much .