The ideal database tool for Oracle development and administration.
Charanya Rajagopalan | TrustRadius Reviewer
October 03, 2016

The ideal database tool for Oracle development and administration.

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Toad for Oracle

This software was used for my client project (a top US bank). Most of the projects across the entire organization used Toad for Oracle although the decision to use a particular software like this was based on two main factors: 1. Budget 2. Suggestion from the technical leads of individual projects.

I was part of the Business Intelligence team and we used Toad for ad-hoc-query analysis, data analysis, to verify SQL logic, database development, code formatting, extracting reports and much more.
  • Ease of use with a well designed and pleasant interface.
  • The Schema browser is very simple and easy to navigate between different levels of a database schema which is a great time saver! It looks simple and its use will make more sense when you use tools that don't have this feature.
  • The ability to run multiple queries in a single window without having to save the queries.
  • Very useful built-in features that help in better code analysis, are easy for comparing different versions of code, extracting reports, query evaluation, code formatting and editing.
  • Better code de-bugging capabilities.
  • Occasionally, the application crashes without warning. Leaving me to start my work all over again. This was not a frequent issue but it does happen from time to time.
  • Being a part of the BI team, we had to code, analyze and compare SQL codes and logics on a day to day basis and Toad for Oracle helped me in achieving them effectively.
  • Time spent was productive as it was simple, easy and robust.
The one big difference in the area of usability is the Object Browser in Toad for Oracle. It's very easy to navigate between different database objects at different schema levels without hassle. This is not true with SQL Developer.

The ability to code and execute different queries in a single window without saving them. It's very useful when we are performing ad-hoc query analysis and a big time saver.
It is well suited for day to day database development, database management, code analysis, query optimizations, executing ad-hoc queries, generating reports and much more.

Toad was used by different teams within our project and was suitable for users of all skill levels:

  • Database development team: For end-to-end database development.
  • Database support team: For fixing bugs in code logics within procedures and functions and for monitoring day to day jobs.
  • Database Administrator: For administering database and automating code analysis, performance analysis etc.
  • Business Intelligence/ Reporting team: For Analysing SQL logics and comparing database vs. report logic and output.
  • QA team: For creating test data and validating various functionalities.
  • Front-end team : For verifying database objects that are linked to front-end application.

Toad for Oracle Feature Ratings

Version control tools
6
Test data generation
9
Performance optimization tools
9
Schema maintenance
9
Database change management
6
User management
Not Rated
Database security
Not Rated
Database status reporting
Not Rated
Change management
Not Rated