7 responses

  1. Kent Graziano
    June 7, 2012

    Cool. I had used the export wizard before but missed the little edit icon for selecting columns.

    Thanks Jeff!

  2. Monika
    June 13, 2012

    I’m using ctrl + c to copy multiple columns…. but then in Excel it pastes all into one column.
    This started when I changed my pc from xp to Win 7… any ideas? It’s driving me insane.

  3. Monika
    June 13, 2012
    • thatjeffsmith
      thatjeffsmith
      June 13, 2012

      Hi Monika, thanks for sharing your question and supplying your own answer! I’m wondering what you did to work around your issue? Did you use the text – column trick suggested on that link? I use OpenOffice, and when I do a paste into a spreadsheet it shows the data coming over on the clipboard as tab delimited.

  4. Monika
    June 13, 2012

    I used the last method suggested, ie pasting the data (in the one column) then doing text-columns as tab delimited. Now, whenever I paste it puts the data in columns *happy dance*

  5. Jeff K
    July 25, 2013

    I have generally been using an older product called Benthic Golden for basic querying in Oracle, but I’m trying to switch over completely to SQL Developer, since it is a more powerful tool. However, one of the features that makes copying grid results to clipboard so easy in Golden is that I can right-click on the grid and select one of the following options… Copy Selection, Copy All (W/O Titles), Copy Selection with titles, Copy All with titles, Copy Titles Only.
    After reading the post above, I now realize that a single click in the grid (to get focus), followed by a Ctrl+A (to select the entire grid), followed by a Ctrl+Shift+C (to copy with headers), will be my equivalent to right-clicking in Golden and selecting ‘Copy all with titles’. Could these right-click options be a future enhancement to SQL Developer?

    • thatjeffsmith
      thatjeffsmith
      July 25, 2013

      Welcome to the world of SQLDev!

      Did you know you can copy headers only? Right click on the column headers, Copy Selected Column Header(s)

      They could indeed be future enhancements. You can add those to our Exchange and see what others think of them.

Leave a Reply

 

 

 

Back to top
mobile desktop