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!

max Number of records in a spool file

Menk SlotMay 13 2010 — edited May 19 2010

hello All,

I want to spool the results of a query into a spool file, but the spool file should only have a max number of records. e.g. 10000

If the result of the query is more then 10000 it should open a new spool file.

I need this because the programm who is handeling the results, can only handle 10000 records.

can someone help with with a solution for this

Regards,

Menk Slot

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2010

Added on May 13 2010

7 comments

8,182 views