I have had a chance to use Oracle SQL Developer rather heavily in the last two weeks, on Windows, OS X, and Linux running under Java 5. All in all I am still very positive about it. It is definitely usable for "professional" work, and I keep discovering more "nice to haves" in the UI that make it a very workable tool for most SQL slingers. It is clear that Oracle really put a lot of effort into building this tool.
When I wrote my original post about SQL Developer, I had already identified some quirks that bugged me, the biggest being the way the context sensitive pop-ups don't seem to fire on "aliases" in SQL. I now have some other new annoyances identified, some of which may be my own ignorance about the software, but some I think are real beefs that I hope they will address in a future build:
- font anti-aliasing not used on all parts of the UI
- code completion always upper case
- "Results" view should allow sorting by clicking on columns
- "Format SQL" processes the whole buffer, not just what is selected
- some weirdness between platforms and navigation (page down on Linux seemed to do strange things for me sometimes)
- no easy way to jump to end of data - scroll bar behavior is a little strange, it seems like it opportunistically fetches additional rows as you scroll down
- When listing objects it only shows you a limited length list. To "Show all" you have to do way too many clicks:
- Double-click on Show More
- Click on "Show All" radio button
- Click on "OK"
Sounds like a lot of complaints, but all-in-all I love the tool and will definitely keep using it heavily.