Tag: Oracle SQLDeveloper Export CSV XLS

  • 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:

    12,345,678
    23,456,789
    34,567,890

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