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!
Twitter
RSS
GooglePlus
Facebook
Aug 21, 2012 @ 05:25:07
Is there any way I can upgrade from 3.1 to 3.2 without losing my settings?
Aug 21, 2012 @ 05:33:59
Allan,
Install 3.2 to a new directory.
Run SQL Developer and it will prompt you to migrate your settings from 3.1.
Aug 21, 2012 @ 07:31:27
Great stuff Jeff! DnD for multiple join is amazing!
Aug 21, 2012 @ 08:37:25
I know every feature can’t be my favorite, but that one definitely makes my Top 5 list
Aug 21, 2012 @ 11:35:13
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
Aug 21, 2012 @ 11:37:19
Where are you seeing this, exactly? I’ll try to fix it ASAP.
Aug 22, 2012 @ 06:47:42
in c:\sqldeveloper\sqldeveloper\doc\welcome\de\welcome.html , the new feature link is pointing to sqldev31
Aug 22, 2012 @ 07:28:49
Here’s the official 3.2 New Features page
Aug 22, 2012 @ 07:29:25
And I’ll look into the translations to ensure if we have a patch it doesn’t go out wrong, again.
Aug 22, 2012 @ 07:58:29
thanks!
Aug 21, 2012 @ 14:08:57
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
Aug 21, 2012 @ 14:14:11
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.
Aug 22, 2012 @ 14:13:41
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,
Aug 22, 2012 @ 15:37:32
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.