Today we released the latest version of Oracle SQL Developer – v3.2.09.23.

The official resources:

I’ll showcase a few of my favorite new features and tweaks in the next several days and weeks, but I thought I’d kick things off right now with a new ‘trick!’

Easily Drag and Drop Multiple Object or Column Names to the Worksheet

We’ve supported Drag and Drop (DnD) from the tree to the worksheet from the very beginning. One of my favorite ‘tricks’ involves building SQL statements with the JOINs automatically generated via the WHERE clause.

Version 3.1 and Older DnD Context Menu

Drag and drop tables or views to the Worksheet

Very nice, but what if I just want the table or object names copied over? Yes, I could use the Intellisense feature in the worksheet. But sometimes I like to mouse things instead of keyboard them.

Version 3.2 DnD Context Menu

In 3.2 you can now ask for the names instead of a statement

When I select my tree objects and drag them over, it simply copies the names over – in the order I clicked them!

Generated FROM and SELECT clauses using SQL Developer DnD to the worksheet

Pretty simple, right? But I’m a big advocate of simple and basic features. I think they can have a much larger impact on the end user’s productivity. This is an example of a feature you might use several times a day/session/hour. Versus using a feature like our Data Pump wizard that you might use just a few times a month.

Simple Feature, But Still Intelligent

If I drag objects or columns from my connection schema, no schema prefix is added. However, anything I DnD from the ‘Other Users’ tree nodes WILL prefix the schema name.

Current schema, no prefix. Foreign schema, prefix. Brilliant!
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

19 Comments

    • Thanks for that, Jeff. Turns out that each query is stored in a separate XML file, but I got the job done anyway by copying the entire contents of the XP history folder to the equivalent on Win7. Thanks for your advice.

    • Thanks for not getting stuck by my horrible answer. That’s what I get for trying to answer w/o thinking!

  1. A very useful and informative article; thank you. Is there a way to migrate SQL history between two PCs? I’ve had to upgrade from an XP box to Win7. The SQL Developer versions are:

    XP: 3.2.20.09
    Win7: 3.0.04

    Many thanks

  2. Michael Kremer Reply

    Is there a more detailed list of all the new features. The document on the Oracle web site is too generic, I would like to know and consequently test all the new features.
    Thanks,

    • The only new features to speak of are the APEX Listener interface, support for 12c and Oracle Cloud, and enhancements to existing features like Database Diff. You can get a more complete set of changes in the Release Notes.

  3. You can also export you settings. I don’t like multiple SQL developer directories around so I usually export my settings, delete the old version, unzip the new, then re-import my settings. And with the export you have a backup copy in case anything else goes wrong 🙂

    • Thanks for the assist Jim! After a few weeks being happy with the new version, I’ll nuke the old ones. Having the backup is always a good idea though! Just be sure it includes your reports, SQL History, etc.

  4. Good that you reference the new features on your blog! When I clicked on “Startseite –> Was ist neu?” in a german version (AddVMOption -Duser.language=de), I only reached the 3.1 new features!

    Ok, not reproducible in English

    • I know every feature can’t be my favorite, but that one definitely makes my Top 5 list 🙂

  5. Allan Lewis Reply

    Is there any way I can upgrade from 3.1 to 3.2 without losing my settings?

    • Allan,

      Install 3.2 to a new directory.
      Run SQL Developer and it will prompt you to migrate your settings from 3.1.

Reply To Laurent Schneider Cancel Reply