I'm currently looking for a good (free) tool to do some PL/SQL development on Windows against an Oracle XE database. I'm looking to develop some stored procedures, functions and packages, and need decent debugging capabilities (breakpoints, variable inspection etc.).
For the SQL side of database stuff, I've been using the TOADfree tool, which seems to have some limitations on the debugging side. Which other options are there?
Quote from SQL Developer Site:
Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements.
I always really liked using the PL/SQL Developer for my stored proc / funcs / trigger work - not free, but not expensive either, and totally worth it!
For interacting with Oracle, I used various of the Benthic Software's Golden Tools which again aren't free, but not expensive at all and worth every penny; they make life with Oracle just that much easier!
Marc
I find Oracle SQL Developer very frustrating to use. It is slow and non-intuitive. If you don't need PL/SQL Debugging, try SQLTools or SQLTools++. The latter is a branch of the former with some 10g-specific features. You may also want to check out jOra Eclipse plugin.