Generating CSV files from tables is a task which we do many a times. But as I said Oracle 10g gives many features , this is really cool, simple solution using xml and regular expressions in a single query.

Withouth specifying the column names is the good point to note