n records at a time

[lesstjm]

Do you want to do this in PL/SQL or just at the command prompt?

If you do it in PL/SQL you can use C1%ROWCOUNT. if at the prompt you might be able to use ROWNUM.