18 responses

  1. Arpod
    July 22, 2014

    Hmm, that works fine with 3 rows, but how about 20? 100? 3000? Thanks, but I value my index finger enough to not click gazillion times before pasting the data :)

    Jokes aside, it would be nice if SQLDev could automatically create enough new rows and paste all the data in there, when user is attempting to paste all the data into the single new row. I think I even saw that suggestion being raised already in the forum and/or exchange sometime before.

    • thatjeffsmith
      thatjeffsmith
      July 22, 2014

      20, 100…use Ctrl+I – just hold it down until you have as many as you need.

      3000 – use the formal import wizard.

      Next time I talk to the developer, I’ll throw your suggestion his way.

      • Arpod
        July 22, 2014

        Oh, that’s cool, thanks!

        Also, you’re right, I totally forgot about shortcuts. Should revisit the preferences from time to time to find new useful things.

  2. Thiago
    July 23, 2014

    Hi,
    I’m using SQL Developer 4.0.2.15.
    But the shortcuts does not work. I’ve already loaded and reloaded all the shortcut keys schemas and nothing happens.
    I really need my “ctrl-+/” back )=

    • thatjeffsmith
      thatjeffsmith
      July 23, 2014

      it’s Ctrl+I, as defined by the defaults.

      Open the preferences, go to the keyboard shortcuts page, and search on ‘insert row’ – that will tell you what it is mapped to on your install

  3. Marcus
    July 25, 2014

    A very handy enhancement of the import wizard would be if he would acknowledge the fact that CSV files in countries where the decimal separator is a comma usually use a semicolon as separator. At the moment we have to rename every .csv into .dsv and afterwards back if we want to use it further with e.g. Excel

    • thatjeffsmith
      thatjeffsmith
      July 25, 2014

      You can open your csv in the importer – although I’m confused, if it’s a csv, why are the delimiters semicolons – and then on Step 1 of the wizard:

      1. change the format from CSV to delimited
      2. change the delimiter to ‘;’

      So no need to re-save the file to a different file extension.

      • Marcus
        July 26, 2014

        There is a world outside the USA where they use commas as decimal separators. In this world it does not make sense to use commas as field delimiter. Therefore we use semicolons as standard delimiter and we spell CSV as Character Separated Values.

      • thatjeffsmith
        thatjeffsmith
        July 26, 2014

        You can use the delimited format, works swell.

  4. Anita Nokes
    August 4, 2014

    I tried the cut and paste from excel and received a very unhelpful error:
    One error saving changes to table xxx
    Where do I look for a more complete explanation?
    Thank you for your posts, I find them most helpful and entertaining.

    • thatjeffsmith
      thatjeffsmith
      August 4, 2014

      That does sound unhelpful. Did the data appear to paste in correctly when looking at in in the SQL Developer table grid?

      Did the log panel that showed the INSERT commands running show any additional information?

      • Stephen
        December 23, 2014

        Ok, just figured out the cause of the error with no information.. My date format was incorrect.. There should be some indication that this is the issue though… Nice blog.. Thanks!

      • thatjeffsmith
        thatjeffsmith
        December 23, 2014

        did you see the INSERTS/ORA’s written to the log panel by any chance?

      • Stephen
        December 23, 2014

        No, there was nothing in the log window other than the generic error. No inserts or ORA errors were ever logged.

    • Stephen
      December 23, 2014

      I also get this error.. There is no helpful information. Before I tried restarting SQL Developer, and then the errors I got were more descriptive.. But currently I only get the generic error- “One error saving changes to table *.*” with no further information… I happen to be pasting info into a table when I get this error every time.

  5. Amy
    August 9, 2014

    I had no idea you could do this! I was actually coming to your blog to look into the Excel importing. I think this is great. I do think it automatically inserting the rows needed would be awesome.

  6. Tony Charen
    September 15, 2014

    Try import feature (right mouse button click on the table name) …

    • thatjeffsmith
      thatjeffsmith
      September 15, 2014

      Yes, cool!

Leave a Reply

 

 

 

Back to top
mobile desktop