Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Spooling into a csv file with all column heading

684135Nov 20 2009 — edited Nov 20 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2009
Added on Nov 20 2009
4 comments
9,863 views