I used to use TOAD, but got fed up with what I consider are a lot of quirks with it (and the fact that it must be licensed per developer and is very expensive). We found TORA a few years ago and I think it is fantastic. It is open source and written in C - thus very fast. It handles pretty much everything as well as or better than older versions of TOAD, at least.
Unfortunately, Quest went and hired the main developer for TORA a year or two ago in an obvious attempt to stifle an OSS product that had already surpassed their very expensive offering. After that, development has slowed to a crawl, but I still wouldn't consider using TOAD instead of TORA even if TOAD was free.
Downside for many/most is that it is most suited for Linux and similar OS's. It is said to be possible to run on OSX which is what I use these days, but for me it is just easier to run it on one of our Linux servers and present it locally on my Mac in X windows. The only annoying thing - and this can be very annoying at times - is that copy/paste into TORA is problematic. I think this is due to the fact that TORA uses the QT library more than anything else.
I used to use TOAD, but got fed up with what I consider are a lot of quirks with it (and the fact that it must be licensed per developer and is very expensive). We found TORA a few years ago and I think it is fantastic. It is open source and written in C - thus very fast. It handles pretty much everything as well as or better than older versions of TOAD, at least.
Unfortunately, Quest went and hired the main developer for TORA a year or two ago in an obvious attempt to stifle an OSS product that had already surpassed their very expensive offering. After that, development has slowed to a crawl, but I still wouldn't consider using TOAD instead of TORA even if TOAD was free.
Downside for many/most is that it is most suited for Linux and similar OS's. It is said to be possible to run on OSX which is what I use these days, but for me it is just easier to run it on one of our Linux servers and present it locally on my Mac in X windows. The only annoying thing - and this can be very annoying at times - is that copy/paste into TORA is problematic. I think this is due to the fact that TORA uses the QT library more than anything else.
Nevertheless, highly recommended.