Toad World® Forums

reading records to end of file

I am new Toad user and still getting use to writing in it.
With that being said, I can only query against 999 records at a time.

Most of my files I query against are a minimum of 3,000 records.
What is the best way to have it read from a table and output the data in increments of 999, until it reaches the end of the file?

1-999
1000-1998
1999-2997, etc