Toad for Oracle Makes Oracle database simple
November 06, 2017

Toad for Oracle Makes Oracle database simple

Robb Glietz | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Toad for Oracle

It is being used by one department. We have different sources which feed data into our Oracle database at a Co-location. Toad for Oracle makes it easy to access the database and work with the tables and schema. When having to either add tables or build out a new database for new data, Toad for Oracle make it a breeze to get those tasks done in no time with minimal effort.
  • One key feature I use all the time is the stored procedure Toad makes it easy not just to create them but also to debug them which speeds up the process to get them down with minimal downtime.
  • The other key feature I just love is the query builder since we have a lot of tables it makes it easy to build a query using data from the different tables by just using the table name.
  • Toad for Oracle makes it easy to connect to different databases via the GUI.
  • I would like to see them build in version control for stored procedures, right now I have to cut and paste the procedure before making changes to it in case something happens in my coding.
  • We use a lot of stored procedures, it has increased the productivity of not just creating them but for troubleshooting.
  • The other area it has shown an important ROI for us is in ease of use, I can get someone trained on using it in a short period of time.
  • Connecting to multi-databases and having them clearly define as to which ones I am connected too, make it easier to know where I am working and not worry I am not in the wrong database before running things.
I was introduced to Toad for Oracle when I started to work with Oracle databases at the start of my career and was lucky enough to work at a company that allowed us to use them. So I have never used anything else. I would not want to spend the time to learn a new program.
In my mind there is no other way to work with Oracle except to use Toad for Oracle, it makes everything you do with Oracle Databases so much easier. The GUI is very easy to use and things are arranged in a way that makes sense. If you do a lot of stored procedure then it is a must-have for it makes creating, troubleshooting and deploying so easy.

Toad Database Developer Tools Feature Ratings

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