Hi Jeremy,
From a quick Google, Oracle 9i pivot table syntax is as follows:
Generates 100 rows numbered 1 to 100.
I'm not sure how this helps you with your problem, however.
I've solved that kind of problem before. If you feel you need more help I'll try and remember how.
Jules