Item: Toad Database Developer Tools
Rating: 9
Author: Sergio Alvarez

Use Cases and Deployment Scope

It's been used by the IT department to manage users, data, reports, procedures, etc. We use as the main program to deal with an Oracle DB 11g, which has all the necessary data to manage all day by day working of university.

Pros and Cons

It's a wonderful tool to get any kind of relational data from tables, apply filters, test examples, Maintain the database, control the users.
It can give you statistics of use, bottlenecks, etc.
It lets you develop and test your own queries and/or PL programs. You can even optimize both of them.

It is only available for Windows. I would like to use it on Linux or even Apple environments but it's not possible right now.

Return on Investment

For me it is an indispensable tool in my work. Accelerates the processes of obtaining and manipulating data and keeps them safe and secure.
I do not work for myself, so sorry but I can not evaluate the impact on objetives in terms of business.

Alternatives Considered

DBeever and SQL Client

I have used some SQL clients like Squirrel SQL or Dbeever before and they are good but do not have all the options and flexibility Toad offers: help on code, data tables browsing, errors reporting, filters, different visualization modes for data, optimization, etc.

Other Software Used

SQL Developer

Likelihood to Recommend

It is great to administrate Oracle DBs and to develop and test your queries to include later (once debugged) in another environment. Maybe it is too powerful to make simple DB tasks, but it is good even in those cases. I think that anyone who works with Oracle DBs should also work with Toad. it 's a "must have" program.

Toad for Oracle Review

Overall Satisfaction with Toad for Oracle