Skip to Main Content
Forums

SQL & PL/SQL

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!

How to enclosed the column with in double quotes while spooling to csv fie

525708Aug 17 2007 — edited Aug 17 2007
Dear Members,

I have to spool a sql to a CSV file. I have two columns to spool one is vendor_id and another is vendor_name. But the 2nd column vendor_name has commas in it so if i see the o/p it looks like this:

Suppose vendor_id = 12790 vendor_name = T T I, INCORPORATED

when i see the csv file it looks

12790,T T I, INCORPORATED

I want each column be enclosed in double quotes like this

"12790","T T I, INCORPORATED"


How can i do this in sql*plus while spooling to a csv file.

Thanks
sandeep
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2007
Added on Aug 17 2007
1 comment
906 views