A simple SQL tool
December 12, 2016

A simple SQL tool

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Toad for Oracle

Toad was used at the New York State Education Department, where I interned for about 8 months during my master's at SUNY Albany. It's used by the whole organization. Toad allowed NYSED to employ interns like myself (with little prior SQL experience) and quickly get them to speed with SQL operations. It was used for all SQL development, and data analysis.
  • Syntax highlighting, and autocomplete
  • Execution plan analysis
  • Debugging complex SQL queries
  • Unable to export stored connection details
  • Cancelling queries takes a lot of time
  • Sometimes it used to crash, could be improved in terms of stability
  • All the employees use TOAD on a daily basis, which has a positive ROI
I have used SQL Developer for Oracle 11g, which does a decent job, but when it comes to selecting a tool, I would choose TOAD. It has a better GUI, and it consumes much less memory as compared to SQL Developer. It's easy to learn and get up to speed while working with SQL.
Toad for Oracle is well suited for big tech firms / government organizations, since it's very simple to use and learn, and is one of the most powerful database tools. It has a simple and nice user interface. I'm not sure where it couldn't be used, since it has a lot less cons.

Toad Database Developer Tools Feature Ratings

Test data generation
8
Performance optimization tools
10
Schema maintenance
9
Database change management
9
User management
9
Database security
9
Database status reporting
9
Change management
9