SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to write a pl/sql which will fetch the first 5000 records from a table and then the next 5000 re

3283987Jul 26 2016 — edited Jul 27 2016

Let say if i have a table "EMP" with 14000 rows in it.

I want to create a condition which fetches the first 5000 rows from "EMP" and then the next 5000 and then the rest "4000". and so on.

How can i loop through the table using PL/SQL

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2016

Added on Jul 26 2016

35 comments

3,796 views