Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking for a good client tool to replace "Oracle SQL Developer" (the tool I currently use) which supports:

  • Oracle DB 10g, 10gR2, 11g
  • Running SQL code
  • Debugging SQL code (with walk-through... click error, jumps to error line)

Do you know of one, preferably free?

share|improve this question

closed as off topic by Mark Storey-Smith, Leigh Riffel, RolandoMySQLDBA, Paul White, Martin Smith Jan 28 '13 at 10:46

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

er.. Oracle is the DBMS Can you clarify what you mean please? – gbn Oct 10 '11 at 12:58
I'm looking for a replacement to Oracle SQL Developer, the tool I currently use to connect to my Oracle database. – A T Oct 10 '11 at 12:59
What specifically is it that you don't like about SQL Developer? – Leigh Riffel Oct 10 '11 at 13:16
That I can't walk-through the debugger. If there's an error, I can't just click on the error and it jumps to the line. – A T Oct 10 '11 at 13:33
@AT this question isn't really a good fit for the site - it is more of an open-ended 'shopping list' kind of question (please see the FAQ). If it gets 'closed' please don't take it personally - and I hope you've found the answers useful - but please consider asking elsewhere for Qs like this as that will help the site keep our focus on more 'answerable' questions :) – Jack Douglas Oct 11 '11 at 6:54

I haven't found anything 'free' that works as well as Oracle SQL Developer. In the past it was pretty buggy and frustrating. I am on a 3.0 Early Adopter release now and very happy with the improvements. I am a heavy user and have had no crashes in the 3 months since going to this release. I wasn't sold on the interface early on but I am familiar with it now and very productive with it. I also make great use of the User Defined Reports -- all the SQL Queries I had floating in text documents for troubleshooting I wrap into their own custom reports.

Toad is an option... but can be pricey. It satisfies your want-list. If you want to pay for all the bells and whistles and have to support a lot of differenct databases it might be worth it for you.

A lot of developers here use AllRoundAutomations "PL/SQL Developer" tool, so many in fact that we bought a site license. Single seats can be had for US$180 per seat. It fits your requirements. I have not personally used the debugger but it is a mature product, I would expect it to work as advertised.

share|improve this answer
"PL/SQL Developer" looks quite good, downloading it now. I've been running SQL Developer 3.0.04 (BUILD MAIN-04.32), seems stable enough. Thanks! – A T Oct 10 '11 at 16:11

While I have grown quite fond of Oracles SQL Developer, have you considered trying Toad as an alternative for Oracle's SQL Developer? (You can download a 30 day trial from Quest's website.)

There is also SQuirrel and DbVisualizer which will work with Oracle (and other DBMS' platforms).

share|improve this answer
Not sure SquirrelSQL or DBVisualizer supports Oracle PL/SQL debugging as OP requested. – David Mann Oct 10 '11 at 13:50
Good points on the alternatives of SQuirreL and DBVis. – RobPaller Oct 10 '11 at 14:17
Downloading DBVI, can someone confirm David Mann's point? – A T Oct 10 '11 at 16:12

The product of Quest Software full fill all need and is easy to use. Currently I am running Toad version 11.

Here is a short demo

But as far is goes to the free software the "Oracle SQL Developer", IMHO the best software to connect with Oracle.

share|improve this answer

For a truly free editor and administrator , try it does have a debugger. not sure if does the jump to error line that you wanted.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.