Toad for Oracle Pros review quotes

KM
Aug 18, 2019
The best product for working with Oracle databases for support, checking and loading data.
BW
Jul 18, 2021
A quite simple feature that I have not encountered elsewhere is the "Make Code" feature. I can easily export a complex SQL statement to a programming language. This is a great timesaver as I do not have to type in all of the escape/concatenation characters just to create a SQL statement in C# or C++.
reviewer1458423 - PeerSpot reviewer
Nov 29, 2020
I find Toad easy to use and I love the Workspace feature, which allows me to set up projects so that I can open SQL files applicable to what I am working on at any particular time.
Learn what your peers think about Toad for Oracle. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Joseph Jolly - PeerSpot reviewer
May 24, 2023
The schema browser is the most valuable feature. The way it presents the objects in our database.
JamesBlack - PeerSpot reviewer
Jan 10, 2020
The most valuable feature is the navigation within the UI, where you can right-click on an object in an SQL query and go right to it, versus going through all of the menus to find what you are looking for.
Balamurugan Ramalingam - PeerSpot reviewer
Mar 28, 2023
Toad for Oracle has proven to be better than other tools since we have never experienced any crashes.
JF
Feb 20, 2023
The tool evaluates non-optimized queries and generates the queries in a way that is more optimal - in addition to giving us some good practices for code development.
Bikramjeet Singh - PeerSpot reviewer
Mar 27, 2023
Oracle has advanced query optimization and tuning features that help improve the performance of SQL queries.
AG
Feb 23, 2023
It is very easy to manage all of the objects.
KM
Aug 5, 2022
I haven't seen any issues with scalability. We have about 1000 people on our IT team who use the solution.
 

Toad for Oracle Cons review quotes

KM
Aug 18, 2019
There may be an issue with processing limitations but this cannot be confirmed as a problem with the product or with the newest releases.
BW
Jul 18, 2021
Once in a while, I may encounter a memory exception and have to abort the application. On a few occasions, the file that stores the saved connections for the New Connection window will become corrupt and I will lose all of my saved connections. I am not sure if that is a Windows or TOAD issue, but it has happened to all of my developers at some point or another.
reviewer1458423 - PeerSpot reviewer
Nov 29, 2020
There should also be a better "cancel query" option as sometimes one cancels a query, but then it still might run for a long time, and then one has to crash Toad in order to cancel the query.
Learn what your peers think about Toad for Oracle. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Joseph Jolly - PeerSpot reviewer
May 24, 2023
Sometimes it works in some areas, but in others, it doesn't. Like when you copy, you find that it's blank and doesn't copy anything. So, there are some objects that do copy, and sometimes they don't.
JamesBlack - PeerSpot reviewer
Jan 10, 2020
The way the dialog boxes appear can be improved.
Balamurugan Ramalingam - PeerSpot reviewer
Mar 28, 2023
An area where the solution could use some improvement is in terms of user-friendliness. During the initial setup phase, the solution was not very intuitive when attempting to establish connections.
JF
Feb 20, 2023
Query optimization is still very resource-intensive.
Bikramjeet Singh - PeerSpot reviewer
Mar 27, 2023
Toad for Oracle does not have a particular resolution within the application.
AG
Feb 23, 2023
I'd like reporting to be more available. If it was a feature that was already installed, more people would take advantage of it.
KM
Aug 5, 2022
Improvement wise, for the user it should show the minimum features on the screen and not all the features. Toad has a lot of features, but most users will use only 5 or 10 based on their role. Nobody needs all the features, and they should provide the option to choose only the required features. Only minimum requirements should be enabled by default. When all the features are shown, the performance is not good; it loads slowly and has hundreds of popups and unnecessary questions.