Oracle Work

Oracle SQL Developer and Commas

Just found an interesting feature in SQL Developer 3

I created a dataset that contained two columns of numbers that I wanted to quickly get into excel. I choose, export in CSV format to clipboard so that I could quickly paste it into an existing spreadsheet.

My dataset contained:

1234, 5678
2345, 6789
3456, 7890

The data that was exported was:


Have to export to an xls file, open it then copy and paste – YAWN !