Quoted CSV Extract

[rohanale]

Hi,

Is there an easy way to get a quoted csv extract so all the column entries are in double quotes?

Or do I have to code this manually?

I only ask because I believe you can do this in TOAD which I used to use not so long ago.

Thanks

rohanale

 

[Marco Kalter]

If you go to Tools > Preferences > File / Format you can control how CSV values are quoted:

The "Export with smart quotes" option controls how values are exported in CSV format. When disabled, all values are enclosed in quotes. When enabled, only those values that require them are enclosed in quotes. These are values that contain comma's or quotes.