4/1/2006 4/2/2006 4/3/2006 Total
John
ModelA 1 2 1 4
ModelB 2 3 4 9

Sara
ModelA 2 2 2 6
ModelB 3 3 1 7

I need to spool result into csv file. The above table did not come out nice in this post. Here is the scenario. John inserted 1, 2, and 1 records of ModelA on dates 4/1, 4/2 and 4/3 respectively. And 2, 3, and 4 for ModelB

Sara inserted inserted 2, 2, and 2 records of ModelA on dates 4/1, 4/2 and 4/3 respectively. And 3, 3, and 1 for ModelB.

Now I need to display this result in a tabular (pivotal format). The last column will be total of each row for ModelA and ModelB for each person.

I received responses from some nice folks in this post but none of the solutions seem to work for my scenario. The number of columns will span to the right depending on the sysdate and I need to display the actual dates as column names. The report will be run by auto sys scheduler and will be mailed to the users as csv attachment. Scheduling and emailing will be taken care of by someone else. However, producing the nice looking format with right data is my headance.

I don't have write permission to the UTL file either. And don't know if that is the right path to take.

Since I am new to plsql I can't seems to figure out the solution.

Please help.
Sum