SQL Developer Wish List

I’m starting to come around to Oracle SQL Developer. At home I only use free software so that’s obviously a big plus, but at work I’m still using PL/SQL Developer (Allround Automations) and SQL*Plus.

These are the features I like best about these products:

SQL Developer:

• Connection management
  • Connection browser
  • Multiple simultaneous connections
  • Password persistance
  • Quick connection switching within SQL worksheet
• Object viewer
  • Easy Query management
  • Nicer plan viewer

PL/SQL Developer:

• Faster startup, smaller memory footprint
• Fully configurable object browser
  • Re-order categories
  • Create/modify/delete categories
  • Colour coding
• Data browser
  • Edit data directly in grid
  • View data, including LOBs, e.g. RTF, XML, HTML, hex, etc.
• Window management
  • Summary tab lists all windows, indicating which are unsaved or are currently running SQL
• Query management
  • Runs DDL and DML in a second session, easy to cancel queries
• Smart SQL and PL/SQL Editing
  • Context-sensitive menus
  • Smarter, context-sensitive code suggestions
  • Configurable SQL beautifier
• Session browser, configurable

I’d like to see Oracle work on some of these features before I switch over at work. I’d also like to see SQL Developer able to export LOBs when exporting tables to XML.