I need to insert a batch 5000 records into a table. Most of the fields will be the same for every record and can be hard-coded in the insert statement, except one which is a number field, and will be sequentially incremented from X to X+5000.

Is there a loop or another way to accomplish this? Thanks

How about a sequence?