Toad For Oracle Reviews & Product Details

Toad For Oracle Overview

What is Toad For Oracle?

Toad solutions are desktop tools that give DBAs, developers and analysts a proactive, automated approach to developing and managing databases, so organizations can spend more time on strategic initiatives and less time on mundane, repetitive tasks. Quest offers several Toad editions, which support databases such as Oracle, SQL Server, DB2, MySQL, SAP Solutions, and more, as well as offerings built specifically for database developers, DBAs and business analysts. Used by millions, Toad for Oracle is the flagship brand in the Toad portfolio, and the leading database development and optimization toolset on the market. Toad Data Point is an analyst toolset, which connects to nearly any data source and is purpose-built for an organization's data provisioning and reporting requirements. Toad solutions help organizations maximize their investments in data and database technologies by empowering database professionals to automate processes, minimize risks and cut project timelines in half.

Toad For Oracle Details
Languages Supported
English
Product Description

Modernize your Oracle database operations to enable business agility

How do you position yourself against your competitors?

Toad is the de-facto standard database toolset for Oracle and has picked-up a tremendous amount of steam across all of the major relational database platforms over the past several years. Because of Toad, Quest has ranked #1 in the Database Development and Optimization tools market segment every year IDC has kept track. Unlike database toolsets that support all database platforms, Toad database tools are built for each specific platform, taking nuances into account, to provide a deeper set of functionality and to support the most recent database versions. Toad is truly the premiere database development and administration toolset on the market.


Seller Details
Seller
Quest Software
Company Website
Year Founded
1987
HQ Location
Aliso Viejo, CA
Twitter
@Quest
18,106 Twitter followers
LinkedIn® Page
www.linkedin.com
3,657 employees on LinkedIn®

Overview Provided by:
Show More

Toad For Oracle Screenshots

Toad For Oracle Reviews

Write a Review
Filter reviews
LinkedIn®
Connections
Popular Mentions
Showing 238 Toad For Oracle reviews
Popular Mentions
Showing 238 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
All Industries
Region
Already have Toad For Oracle?
Write a Review
UF
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

the session browser is fantastic, it's a life saver when you have locks and badly tuned sql , nothing easier than session browser to catch them. Review collected by and hosted on G2.com.

What do you dislike?

the sql editor is not doing the auto complete for the object names (tables, columns , ..) which make writing the sql statment a bit diffecult specially in the huge schemas where you have thousands if objects. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

maintaning my Oracle DB:

- writing sql to maintain the data (updates, selects , inserts , delete).

- doing the daily health check for my Oracle DB.

- wringing pl/sql. Review collected by and hosted on G2.com.

Show More
Show Less
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

It has easy access to different and variable instances and schemas, one of the most striking points from my point of view, which makes it one of the ones I like the most, regarding its storage functionalities, including its storage capabilities. Monitoring during the execution of a particular project, I like that its interface design transfers emotion and charity, it is implicit to want to offer its innovative information in every aspect that occurs internally in the development of the platform. Review collected by and hosted on G2.com.

What do you dislike?

The toad is high cost, which implies that it operates only with high-performance companies that can be medium-sized companies, since obviously small companies cannot because they are not at the limit of their budget, we can highlight that not all Tools are not easy to understand and navigate in the online web application, and lastly, error handling is not as accurate as it should be for spelling and grammatical deficiencies in schemas or other designed system operations. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Exporting valuable information to the database in spreadsheet format, highlighting everything in general, has acquired a platform session monitoring option in real time, it is easy to install in common workstation operating systems, it is for its management of news storage, it recommends service administration that offers different considerable instances and schemes with excellent interpretive and intuitive performance. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

In general terms, its operation is used in various aspects in our company for the adequate and organized administration of the data we store, which implies different accessibility packages for better performance by category, daily sequences, procedures and verification schemes moderation, which we use primarily for its complexity in business analytics and quick search data management. Review collected by and hosted on G2.com.

Show More
Show Less
Open Discussions in Toad For Oracle
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

The best part of this tool is that it provide a lot of feature to generate automated queries. Different formats of reports can be exports based on data in oracle without any complex queries. Easily determine the error in scripts. Review collected by and hosted on G2.com.

What do you dislike?

The hanging problem bothers a lot. It consume a lot of resources. But it's an obvious problem as this tool has a lot of feature. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Please go for this if data security is your main concern and want some automated features for report generations. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

It helps us to write complex queries, Packages and managing data in oracle. It is highly secure and grant permission given based on user roles. Review collected by and hosted on G2.com.

Show More
Show Less
UC
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

The product is easy to connect to database, extract data in different forms Review collected by and hosted on G2.com.

What do you dislike?

We would need special edition to upload data from excel and do the calculations, which is a draw back Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Excellent tool for starters with non technical background, easy to build queries and extract huge data. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data analytics and financial reconciliation. Easy to consolidate the data with the required analysed format. Review collected by and hosted on G2.com.

Show More
Show Less
UF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

very easy and readable interface

settings and tools are easy to configure Review collected by and hosted on G2.com.

What do you dislike?

sometimes finding issues with query becomes difficut Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Sql Queries writting Review collected by and hosted on G2.com.

Show More
Show Less
Business Data Operations Analyst
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

As a novice SQL user, I like that TOAD includes features for exploring the data and building code. It is helpful as I become more familiar with SQL syntax and with my organization's data warehouse. Review collected by and hosted on G2.com.

What do you dislike?

Sometimes it is hard to navigate between the visualize and build and explore and edit code menus. I feel like it can host many tabs which feel like layers that I can lose things in. It is also frustrating to have to re-establish the connection to the warehouse every time I log in, maybe this is standard with querying systems. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Querying any type of data that I need that is up to date without relying on pre-built reports or extracts.Toad is an easy way to parse through large data sets to answer questions with the most up to date data available in the warehouse. In our industry, this is particularly helpful for claim and enrollment data. Review collected by and hosted on G2.com.

Show More
Show Less
Research and development associate team lead
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I like toad it helps me a lot to develop PL/SQL tables/views/function/ procedures, the editor in the tool it will help you to recognize and fix syntax error also there is a lot of features allowing you to debug your code and optimize it and find unusable variable and also it helps using the wizard base to create procedure selecting specific element Review collected by and hosted on G2.com.

What do you dislike?

Sometimes the application crash or freeze specially when it load large files or plsql code. also when i try to execute large sql script using the editor it will take long time so i prefer to use SQL Plus to run large SQL script Review collected by and hosted on G2.com.

Recommendations to others considering the product:

I highly recommend anyone who want to build new career path in Oracle database PLSQL to start learn coding using this tool it really helped me a lot to be a good developer Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

The tool helps every developer to create tables views functions procedures packages users and setting roles to specific users also the tool help to debug you code and find errors also it help a lot to optimize performance and monitor the performance in order to tune it Review collected by and hosted on G2.com.

Show More
Show Less
Financial Analyst
Financial Services
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I enjoy the ease of dragging and dropping tables, and the ability to do quick manual edits through SQL statements.This creates a user-friendly experience, where many users are able to create their own queries. Connecting to databases is simple, and users can save various schema of tables to return to at a later time, reducing the need to configure the views upon each login. Review collected by and hosted on G2.com.

What do you dislike?

The lack of ability to create groups through the selection of data, rather than SQL statements, can be frustrating. This causes some users with less experience in the tool to need greater direction from more experienced users, or our IT group. Training was offered through our company, but not through Toad experts or representatives. This caused some dysfunction and gaps in knowledge with implementation. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

This is a great tool for those who need drag and drop capabilities, but some users will need to be able to understand basic or advanced SQL statements. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Our work required a transition from a system without security or tracking abilities of users through data sets, to Toad. We are able to better track users and IT has greater control of data usage. We have also utilized SQL more throughout our system to edit and manage queries, or share these queries with each other. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

The ease of use and the features that Toad for Oracle has been excellent and unmatched compared to others. Obviously, we shouldn't compare the freeware with Toad for Oracle. But the amount that we spend is well worth. Review collected by and hosted on G2.com.

What do you dislike?

I havent really come across any that I need to highlight. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

The software is definitely a great tool not just to retrieve the data but it has other add-on software which we use to automate processes using windows scheduler. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We use Toad for oracle to connect to our oracle databases. It helps us retrieve data(of course) and BLOB, CLOB etc features and other small features it has. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: G2 Gives Campaign
What do you like best?

I'm using this tool since last 5 years infect more than this and I can say that yes this is very good if you want to manage or wanted to get in touch with your db like you are sitting in the front of your database. As it make you feel like that. I didn't face any issue while using this. Review collected by and hosted on G2.com.

What do you dislike?

I don;t have any reason to say if I disliked it ever. So in my opinion there is nothing that wouldn't like. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

While working for our project to get information from database or for correction purpose I have used it. Also for getting information of packages scheduling of procedures and getting information of inavlid objects and much more. Review collected by and hosted on G2.com.

Show More
Show Less
Principal Consultant
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Organized and customizable user interface; coverage of all database related activities; reasonably easy and intuitive; Review collected by and hosted on G2.com.

What do you dislike?

Been using it for years and have yet to find something to truly dislike. If I had to make *any* suggestion for improvement then it would be to give the UI a fresher look but that’s just personal preference. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Perfect for anyone comfortable with SQL who wants to make their lives easier Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Quick access to the database backend for queries and simple to moderately complex SQL statements. Review collected by and hosted on G2.com.

Show More
Show Less
UB
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Schema Level Management: Toad for Oracle enables you to conveniently generate and retain schema items. It's the best GUI interface in this software class. Learning and getting used to is simple.

I like the convenience of using Toad for Oracle characteristics such as SQL Loader, Export / Import, etc.

The toad's performance analysis module also provides a very solid graphical analysis of queries Review collected by and hosted on G2.com.

What do you dislike?

The complete characteristics of the company come at a price. Dell should believe about how tiny businesses can make this great solution more feasible.

For non-RDMS DB customers, Toad is not a very large player. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

What I believe is the best in this software is that you do not have to work with other instruments to have a full atmosphere within the database.

Toad is suitable for sophisticated users such as DBA. I was an analyst, so I had a harder time to use it. I'd think that DBA's elevated standard of customization would use it without any issues. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Toad for Oracle is used in our organisation to handle databases. SQL Builder helps to create queries for extracting information from oracle databases. It is used throughout the organisation so that the same information is available to everyone rather than having local databases in their scheme. Review collected by and hosted on G2.com.

Show More
Show Less
Associate team lead Research & Development
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

This application help all oracle database developer to create database elements and objects easy, actually the editor of this application and the debug mode helps me to create procedures and functions very fast and it helps me to export reports addm and tune performance Review collected by and hosted on G2.com.

What do you dislike?

Sometime the application crash and executing large script using the editor stuck and crash Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Very easy to use and it help beginners to write plsql code and help experts to monitor and control database using this tool Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Writing functions and procedures and creating tables and indexes

Export dump file and importing it

Create users and set permissions and assign role

Monitor performance and find errors Review collected by and hosted on G2.com.

Show More
Show Less
Sumit
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Toad for oracle is very easy tool to access the database. We can easily learn this tool. Toad for oracle is very easy to set up. We can easily update the database.We can easily do the entries in the database with the help of SQL in Toad for oracle. We can remove or delete the entries from the database. We can save our authentication details in this tool so it will not ask for id again and again. Review collected by and hosted on G2.com.

What do you dislike?

Sometimes it is very slow to access the database and takes the time. There is no GUI implemented in this tool so we have to type all the things manually. Sometimes it asks for license again and again whenever we are trying to login that is the waste of time. It should save the license and do not ask again and again. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Toad for oracle is very easy tool to access the database.We can remove or delete the entries from the database. We can save our authentication details in this tool so it will not ask for id again and again. We can execute the selected line only. We can do the entries like update, create, delete easily in the database with the help of Toad for oracle. Review collected by and hosted on G2.com.

Show More
Show Less
Software Engineer
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

We can easily access the database with the help of toad. Toad is very easy to use. We can easily use Toad for database entries. Toad saves the time to maintain the database. We the easily find the updated entries in the Toad. We can easily remove or delete the entries from the database. We can save our authentication details so we don't need to login again and again. It saves the time. We can execute the selected line only. With the help of SQL query, we can easily see the related data in the Toad in well orderly formed. Toad is very easy to learn as well as easy to setup. Review collected by and hosted on G2.com.

What do you dislike?

Toad is very slow. Sometimes it takes more time to complete a task. We need to type the each and everything. It doesn't support GUI. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Toad saves the time to maintain the database. We the easily find the updated entries in the Toad. We can easily remove or delete the entries from the database. Toad is very easy to learn as well as easy to setup.We can easily access the database with the help of toad. Toad is very easy to use. We can easily use Toad for database entries. We can save our authentication details in Toad. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Developer
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Most effective and easy to use DB Management tool. Same tool can be used by DB Developers, Administrators, and Data Analysts to manage SQL Database. It auto detect syntax error in SQL query. It helps to reduce time and effort required to develop and manage rational as well as non rational DB. Review collected by and hosted on G2.com.

What do you dislike?

Everything we need to type, if there will be options for selecting from GUI then It might be more helpful. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Most effective and easy to use DB Management tool-set. It can be used by DB Developers, Administrators, and Data Analysts to manage SQL Database. It auto detect syntax error in SQL query. It helps to reduce time and effort required to develop and manage rational as well as non rational DB. Review collected by and hosted on G2.com.

Show More
Show Less
AF
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2 on behalf of the seller
What do you like best?

Ability to connect to many data sources. We connect to local and cloud databases and move information from one place to the other seamlessly. Scheduling works like a dream and is super reliable Review collected by and hosted on G2.com.

What do you dislike?

There are things that are not simple to figure out - for example, automation of complex excel reporting is not obvious Review collected by and hosted on G2.com.

Recommendations to others considering the product:

When you are working with an Oracle database (or any database that works with Toad) then buy Toad. Especially if your business heavily relies on the ability of systems to upload, transform or extract data - this is the place to be. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

ETL for our database related processes. We collect a massive amount of data from our data providers, the likes of Reuters, Markit, large housing associations and we process this data to add value. We also run an extensive operation involving valuations of complex derivatives that require a massive amount of data to be processed, saved and applied across different applications. Toad has made the development of these processes agile and easy to work with. One of my favourite features is the verbose logging which pinpoints where particular jobs have failed. We also use it as an alert tool which monitors the presence of expected data using preset tables. This aligns us with regulatory obligations that require us to have systems that check for the presence and accuracy of the data we work with. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Good GUI, very intuitive, there is not much training that is required to start using it. Administrator module is also quite useful that can give you insight like explain plan, session wait etc. Review collected by and hosted on G2.com.

What do you dislike?

Its a licensed tool so there is a procurement that we have to go through where as SQL developer is free and prety much does the same things with slightly poorer interface. Some time if you leave a box clicked then it will lock the row and can create issues with the database sometime. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Its a great tool but in the times of cost cutting procurement team will ask you for a justification. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Writing business reports, Writing PL/SQL queries. also performing database performance tuning activities. Review collected by and hosted on G2.com.

Show More
Show Less
Global Data Migration Manager
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2 on behalf of the seller
What do you like best?

This tool was instrumental in the major ERP implementation over the last 6 years. Comparing data from one system to another could not be easier because of the cross query capability. Saved many hours! Review collected by and hosted on G2.com.

What do you dislike?

Difficult finding answers to solutions and issues that I encounter. Would like to see a better organized user community for questions and answers. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If implementing a new ERP and you intend to migrate data, Toad is great for querying across different databases. This is a major activity in an implementation and comparisons of data any other way is just to time consuming. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Cross Query is a huge benefit. This element in Toad is well worth it, without the automation. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Software Test Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Toad is user friendly as compare to SQL Developer.Toad is an Oracle product. Toad has many feature like session monitor, DBA tools. Review collected by and hosted on G2.com.

What do you dislike?

Toad for oracle is not a open source. we have to purchase this software. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It is useful for data base developer and Tester. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Toad software is ease to use for new user. We can easily view our data base structure. we can create index, primary key and many more functionality set through GUI. Review collected by and hosted on G2.com.

Show More
Show Less
Associate Manager
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

The GUI of the product makes it easy to understand table structure created with the help of sql scripts. Review collected by and hosted on G2.com.

What do you dislike?

The application sometimes give an error for not being accessed by a logged in user. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It is a nice tool for understanding the basics of table structure. Other option will be SQL developer. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

the parameters allows to get the scripts in a formatted way and errors occurred during execution can be seen with which error solving is reduced. Review collected by and hosted on G2.com.

Show More
Show Less
System Administrator
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2 on behalf of the seller
What do you like best?

Ease to connect, query, and publish queries or data. Review collected by and hosted on G2.com.

What do you dislike?

It is hard to query 2 different data sources without having to query both, load into an intermediate source and then merge the data Review collected by and hosted on G2.com.

Recommendations to others considering the product:

This is a lot easier to use than using other tools that we had reviewed. It is a little pricey, but worth the cost. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are automating queries and reports with ease now. We additionally now have a very nice way to store our queries into a centralized repository using Toad Intelligence central. Review collected by and hosted on G2.com.

Show More
Show Less
Finance & Analytics Manager
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2 on behalf of the seller
What do you like best?

Despite what many others would say I quite like using the GUI. The views are also easily customized. Review collected by and hosted on G2.com.

What do you dislike?

I wish some of the menus and objects were more intuitive. Sometimes I find myself digging through menus for options and the errors are difficult to decipher. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

I would spend time understanding your data and learning some basic SQL skills before diving in. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We solve both clinical and financial problems with Toad. We find quick access to our data when using the tool. Review collected by and hosted on G2.com.

Show More
Show Less
Aneeta Alex
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

It is really well-organized. We can create multiple connection to a database. Review collected by and hosted on G2.com.

What do you dislike?

It takes longer time to execute the command when there are lots of records getting effected. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Its is used to insert, update, delete records from a table in a database. Review collected by and hosted on G2.com.

Show More
Show Less