Try our new research platform with insights from 80,000+ expert users
 

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: October 2024.
814,763 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
Aug 21, 2024
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.
Eniyavarman Nandhivarman - PeerSpot reviewer
Nov 1, 2024
One of the most valuable features of Toad for Oracle is its ability to manage sessions by killing those that are hung or blocking other sessions.
AG
Feb 23, 2023
It is very easy to manage all of the objects.
 

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: October 2024.
814,763 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
Aug 21, 2024
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.
Eniyavarman Nandhivarman - PeerSpot reviewer
Nov 1, 2024
It would be beneficial if Toad for Oracle could incorporate OEM features, as having monitoring capabilities in the same interface would simplify workload and management tasks.
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.