CSV file enclosed by "

[bky88]

Hi all!

I need some help with a csv file im exporting. The file is coming like this:

000050222,1,AB2 500AW,2007,10,3 2,2,+1.00

and i need to enclose some colums with double quotes so the file could look like this:


000050222,"1"," AB2500AW","2007 ","10","32","2" ,"+1.00"

im using oracle 10g, on Unix OS, and im new to Oracle


Any help will be useful.
Thanks!

[Pilgrim333]

Hi,

You can escape it by using "" eg.

Select ""test"" from dual;

Will result in "test"

Pilgrim.

[amitpatel66]

Please post your query that you are using to export the data from oracle table in to a csv file?

[Pilgrim333]

My Booboo,

That ofcourse should be

 select ' "test" ' from dual

Using it in a pl/sql procedure in which you are generating an output string it would be

 l_text := ' " ' <variable> || ' "; '  <etc> ;

(get rid of the spaces between the single and double quotes)

Pilgrim