Answer Posted / Himanshu
To implement paging in Oracle, you'll need to handle it in your application logic. Here's an example using two queries:
1. Query for the total number of rows: SELECT COUNT(*) FROM my_table;
2. Query for the actual data, with a LIMIT clause and OFFSET calculated based on the page size and page number.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to select all columns of all rows from a table in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to write a left outer join with the where clause in oracle?
How to start an oracle instance?
How to use values from other tables in update statements using oracle?
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
Design database draw er diagram for a certain scenario ?
