Quote Originally Posted by omega1966 View Post
If there are 5 million records in employee table , then how will I process those records .
With a LOOP?
It's right there in the fine Oracle® Database PL/SQL Language Reference.