Thanks dave,
I can generate it through SQL plus that way, but it is a bit tedious.