The pagination techniques with the Oracle RDBMS (external link)

Quite extensive overview of pagination techniques. And here an article from J. Lewis on the same subject.