Originally posted by chrisrlong
BTW, considering what we do know about this model, I shudder to think about why they might actually have 3000! tables.
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...