Toad Tool

TOAD (Tool for Oracle Application Developers): a graphical TableBrowser tool for ad-hoc queries to an Oracle database. Kinda' like SQL*Plus on steroids.

It's really quite good; doesn't look like a typical VB "lots o' forms" app at all.

How can they call the "freeware" version freeware if it expires? Is that really freeware?

ugh... TOAD is great conceptually but has so many small nuisances that I categorize it as a poor implementation. For example, the commit button gives no feedback (did something happen or not?). The constrained MDI interface is a gigantic pain when trying to work with more than a couple windows. Column width settings in a data view are never saved -- you can modify the widths to your heart's desire, click away to another table, and find that all the widths were reset when coming back to the table. There's no easy way to hide columns in a table without creating a view (too much work if you ask me).

Maybe if the little things were cleaned up I would consider this a good tool, but currently, it goes against the grain of so many things that AlanCooper (inventor of VB?) said in AboutFace. Compared to SQL*Plus, though, it's fantastic.

And, for some reason, the minimize, maximize and exit buttons on child forms keep disappearing. Very odd.

Yes, it's a >big< improvement over SQL*Plus.

Also, you can have only one running at a time, and it locks up on long queries: Run one of our stored procedures that takes 40 to 50 minutes to copy loads of data between databases. All TOAD windows lock up until it finishes, and you can't bring up a 2nd (unlocked) copy of the program. This limitation can force you back to using SQL*Plus, which is such a crude tool that you can run as many copies at once as you'd like.

Clearly, many of the above comments are from much older versions of TOAD. The current version saves column widths, allows hiding of columns which is also saved. Min/Max button problem has been resolved. Oh, and TOAD wasn't written in VB -- it's a Delphi app. It was originally written in VB but was converted over 2 years ago.

Oh, and the MDI interface stays until something better comes along. The floating/docking SDI interface in VB and Delphi are NOT improvements over MDI.


Actually it DOES NOT save column widths. I am using the latest version and it doesn't remember the width I set my columns to. Try this, do a select on a table with a large NVARCHAR2 field, do an insert into the table, now do a reselect, doh! The big ol' column is still a big ol' column. Doh! and double Doh!

Shaddam IV

Why all these aversions against sqlplus? Oracle is not a simple product that you can get thorough knowledge of with point and click. Using a 'crude' tool like sqlplus will help you to really know Oracle. OK, maybe it is the hard way, but you really know Oracle after using it a few months. After that, you can use TOAD. It is not bad. But know how to do things the hard way, because there are things that only work the hard way. sqlplus is nothing more then a simple sql interface, but for all sql. If you do not know ho to it by pure sql, you might not even get the idea that you could use the sql worksheet of TOAD (which is just like sqlplus). I never saw a TOAD user write sql meta scripts...

And what to do if your network is down, and you must do some maintenance on a server where TOAD is not installed? You want to start learning sqlplus right at that moment? Forget it. And of course, you all refer to sqlplus for windows. In a UNIX environment you have such a lot more possibilities. As a DBA, I use TOAD for the few nice features that cost too much time to do myself with sql scripts. So on average I start it up 1 time per month...

I had difficulty getting Toad to compactly display columns. In some cases it would not let me drag the column borders closer together (I couldn't figure out the pattern for when it let me and when it didn't). Also, it should give the option of using a font other than fixed-pitched for its grid. And, it would not remember my column arrangments on the next instantiation.

The UI is pretty bad, like others said. You can't even right-click on a resulting grid cell and copy the text! Also, window management is a nightmare as they use the gray background color that is exactly the same as the drg box. So basically you have to adjust your OS display properties (show window while dragging) to use a single app? I think not. There are way too many icons in weird places, causing clutter, etc. Finally, I've never ever created even one stored procedure that Toad formatted properly. It does aggressive TabMunging, it's as if, when pressing enter for a new line, a die is rolled and a random amount of tabs are added.

See TableOrientedToolWishList, WhatsBeenDoneInVbClassic, WhatsBeenDoneInSmalltalk

View edit of April 30, 2012 or FindPage with title or text search