Spooling into a csv file with all column heading
684135Nov 20 2009 — edited Nov 20 2009Hi,
I am using spool command to query my output into a csv file.
The problem I am facing is , when I open the csv file using excel, all columns of a sql query are getting displayed in single cell of excel. each column output doesn't show in each cell of a row. How do I get in different cells of excel.
Also may be because of this, Even though I wanted heading it doesn't appear (with heading on option)
Pls. let me know.
Thanks