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.
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.
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.