1

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?

  • 1
    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
  • 1
    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
5

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.

  • "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
1

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).

  • 1
    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
1

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.

0

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

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