Using CF and a very large Oracle table, how do I view "pages" of say 20 records at a time without having to retrieve the entire table each time? I am trying to solve a performance issue here.
Using the SELECT * FROM TABLENAME query may return several thousand records. I need to limit the query somehow by "page" number. eg. I want page 3 of that same query, showing 20 records.