Commit for every 'n' records in 'insert... select from' .

[gandolf989]

Originally posted by marist89
Because Oracle can only have 1000 columns and they needed:
PAY_DATE_2201, PAY_AMOUNT_2201, PAY_DATE_2202, PAY_AMOUNT_2202, PAY_DATE_2203, PAY_AMOUNT_2203, PAY_DATE_2204, PAY_AMOUNT_2204, etc. to implement multiple pay_dates and pay_amounts...

I agree a fully denormalized schema is the mark of every good programmer.