Version 3.1 and Older DnD Context Menu

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.

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.

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.

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.