Thanks for the input. I'm currently doing the this using Crystal Reports. However, the drawback is in getting the report in ASCII/text format. Looking at Crystal Reports Distributor for this.

However, if I could do the same using PL/SQL, I'd be glad.

Originally posted by abhaysk
Or u cud write a proc to handle dynamic result set to be actually displayed as row, rather tahn col.
Can you eloborate on the above with an example, links please?

Thanks.