I have columns which needs to be generated as CSV file. The problem is that one column value has three commas in it. so it creates three seperate columns in CSV file.
E.g
Select DOC_TITLE AS "Document_Title".
Value: STEELWORK DRAWINGS VESSELS (PLATFORMS, LADDERS, CATWALK) - UNIT 1400 TRAIN 6 STRUC. STEELWORK AREA 8 PLATFORM FOR V-1202
In the CSV file it gives me three columns
Column 1 = STEELWORK DRAWINGS VESSELS (PLATFORMS
Column 2 = LADDERS
Column 3 = CATWALK) - UNIT 1400 TRAIN 6 STRUC. STEELWORK AREA 8 PLATFORM FOR V-1202
I am using Oracle 11g and Oracle developer
What do I do in order to have the entire column value fit into one column in the CSV file
Appreciate any help.