Reviews (1-25 of 35)
- Easy connections to databases
- Easy to use UI
- Robust Debug Tools
- Great Explain Plan breakdowns
- Excellent Customer Support and Training
- Too many versions and options
- Licensing too confusing across various versions and upgrades
- Tools, tools, tools... for a developer this is a dream product. You feel as if you're in a airplane cockpit where the whole database is at your full control.
- Quick links or shortcuts are particularly handy, write down a table name and shortcut directly to the definition. Same goes for packages and stored procedures.
- If you know your way around, development goes really fast. One reason for this is the endless ways in which you can add screens and windows.
- The power and control it gives is at the same time kind of a negative thing. There's too many options available, even when you don't need them. For simple database operations it's sometimes easier to just use SQL Developer since navigation is way more intuitive and easy.
- Related with the above: there is a steep learning curve. However, since this is the main tool for any Oracle developer, this is not that much of a problem.
- If I remember well, Toad used to be free, some 20 years ago. Or at least had a free version. It would be nice to have a free version. The dedicated Oracle developers and DBA's won't use the free version, but all the rest of us developers might use it instead of SQL Developer. It would make communications between everybody somewhat easier.
- Best for quick reporting for business
- Identify data discrepancies in target database
- Impact analysis and analytical reporting
- Easy connections to database
- Easy access to schema instances
- Multiple database support and connections
- Explain plan can be better
- Bit costlier
- Not so helpful to non-Oracle developers
- Giving scripts for table modification commands.
- Easy access of different instances and schemas.
- Capabilities to monitor running packages.
- Speed as to which changes can be made.
- Efficiency of the tool.
- The user interface could be better.
- Easy to install interface to Oracle RDBMS.
- Ability to export data to many different spreadsheet software formats.
- Converts common query language to standard ANSI SQL.
- Toad is high-cost.
- Not all tools are easy to navigate nor understand.
- Error handling isn't as accurate as it should be.
- Accessing Oracle RDBMS
- Exporting database data into spreadsheet format
- Cross-database implementations (connecting different database software, i.e. bridging Microsoft SQL server to Oracle RDBMS)
- Real-time database session monitoring
- Visibility into database metadata without requiring explicit knowledge of data dictionary
- Easy to install on common workstation operating systems
- Access to RDBMS procedural code outside of non-graphical interfaces (i.e. ability to call dbms_datapump)
- Database query execution
- Connection to various database
- Multiple DB connections
- DB query optimization
- DB query auto formation
- Improve explain plan
- SQL Formatting
- Running multiple SQLs as multithreading operation
- Data extract exports
- Better syntax error information
- Auto tracing options
- It is user-friendly for the most part.
- It has all of the features you expect from a tool like it.
- It allows you to run more than one query against the same database at the same time.
- The date/time settings in Toad are kind of difficult to figure out. I have to use an ALTER SESSION command to format the dates so I can actually query date/time fields.
- It seems to be updated too often. I get notifications very frequently about new versions being available.
- The export function is difficult to use.
- I appreciate the library feature that enables me to label and store previously created statements. These are saved off to a network share for future use.
- I also really like the describe function that lists all fields in a table. This helps as I build new queries.
- I wish I was better at using the tuning function. I have seen others use it and am very impressed with the graphical depiction of query costing.
- I don't have any unmet needs from this tool. I mostly need more time to be able to get in and take advantage of its existing features.
- Sql database queries.
- A developer database tool.
- Integration support.
- License support that is manageable.
- Previous version support.
- Better installer and push support.
- Schema Level Administration: Toad for Oracle allows you to create and maintain schema objects conveniently. It's GUI interface is the best in this class of software. It's easy to learn and get used to.
- Performance Monitoring: You can monitor database performance and long running transactions using Toad for Oracle interface. For most of the performance issues reported, i prefer using Toad for Oracle over Oracle's native tools like SQLPLUS or OEM.
- Data Modelling: You can develop data models for your database design and generate scripts to create the objects in the database instance.
- I like the ease with which Toad for Oracle lets you use features like SQL Loader, Export/Import, etc.
- It sometimes hangs up if you are working on multiple Toad instances in parallel.
- If you are running some few thousands statements through Toad, it's better you do it directly through SQL Plus interface. It takes way longer if you do it through the Toad for Oracle interface.
- Toad for Oracle should consider including some graphs and histogram charts for performance monitoring . This will be especially useful for non-technical users like project managers.
I don't recommend Toad for Oracle for Project Managers or Solution Architects. This can be a pricier choice for these people. They can do fine with free options like SQL Developer.
- The UI of Toad has not changed much from the earlier versions and thus developers can focus on what they do instead of having to pay attention to the many redundant features which seem to come up every year.
- Designing a query in toad is a breeze. It also helps while taking data dumps.
- Performance analysis module of toad is also very robust providing graphic analysis of queries.
- Toad is very reliable.
- The full enterprise features come at a cost. Dell should think about how this wonderful solution can be made more viable for small companies.
- Toad is not a very big player for non-RDMS DB clients.
- All newer linguistics are not recognized by Toad.
- Manages huge volume of data and provides a platform to run queries. Not very expensive.
- The SQL builder really helps those who are new to SQL. Very well integrated with other applications.
- Very intuitive and user-friendly with lot of features and functionalities.
- A Python platform to write scripts which can be used to extract and manage data would be really helpful.
- Needs to be linked to more applications to import data such as SharePoint.
- Reduced cost is like icing on the cake.
- Import/Export function where we are able to export the data in any of the format like .csv, xlsx, .txt etc., according to the number of rows required.
- Database diagram - Easily able to generate the database diagram which will shows the relationship between objects.
- Toad automation scripts and formatting SQL scripts for developer.
- Transform function and cleansing the data.
- License Key is costly since we have to pay rather than open-ended tool.
- Some of the SQL commands are still not recognized by Toad like (NOSQL), PIVOT etc.
- Reporting will not be exact since this is not owned by database production. An example of that is SSRS reports run by Microsoft.
- Easy interaction with data
- Interactive tools to build out SQL for individuals that are not as comfortable with SQL
- Can allow business administration teams to quickly make changes to database and monitor process that are running on the database
- The tool does have a tendency to freeze up when multiple windows or browsers are open
- When looking at data it would be nice to be able to right click on a row/column and say filter on that individual column and value
- More tools to interact with XML Clobs within a table
Toad is a crucial tool for our department as we have limited front-end access, and therefore we have a controlled platform to query tables/packages where differing levels of rights and access is granted for HR/Finance respectively.
- Quick querying of data and debugging of issues which is particularly made easier with the stored procedures function and has a very friendly user-interface.
- The use of a stored TNSnames file for accessing the different environments makes it very simple to connect to different databases.
- Creating and editing packages is very simple and allows you to toggle different views of the package which is very handy when they are of such a large size.
- Version control on stored procedures - currently not something which is available
- To allow scheduled reporting remotely without the need to be physically logged into the software
- 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.
In my book: Toad for Oracle Unleashed, chapter 10 is 'Toad as a SQL Tuning Tool'. The Toad team has made performance tuning of SQL very easy.
I use Toad for light development, as a data query tool, and as a SQL performance tuning tool.
- SQL Performance Tuning. The Toad team has done a great job with explain plans...and DBMS_XPLAN displays as well. They have also included 'advanced' explain plan features that one would have to use SQL*Plus to get otherwise. The Toad Team has a great Trace File Browser that takes you right to the poorly performing SQL.
- Toad for data analysis. Toad is a great query tool. If you don't know SQL, Toad has this great Query Builder that is a drag/drop operation that will create simple to advanced SQL just using your mouse. You can then export to a nice report writer and Excel. Most export to Excel.
- Oracle code development. Toad is simply the best with its templates, ability to condense and expand code...and allows you to add your own short cuts to help customize Toad to your programming needs.
- I've wanted the Toad Team to make some of the more advanced features available on more affordable packages. Right now, I can't think of any functionality that is missing that I turn to another tool for.
- Toad now does ( ) matching...this is something I used to have to use the vi editor for...but now Toad covers it. Toad also covers brace and bracket matching.
- The Toad Team did add my QBLOCK_NAME stuff...that is super helpful when performance tuning SQL that contains sub queries. We worked together on this and now I can use Toad for this type of tuning as well.
Toad is a good development GUI. Toad is great for data retrieval, even for the novice... Toad is a great SQL tuning tool.
Many platforms [designed] to manage a database are intended to simplify the management of databases. Although generally in large companies their DBA is responsible for supporting these issues, many companies still look positively on using these tools to control their operations’ databases. And not only in positions such as a DBA, but in positions where software development database management tools are mostly welcomed for the simplicity, ease of use and speed they offer in their work.
Of these existing tools for Oracle SQL - we find Toad as the most versatile among them in terms of simplicity, ease and speed alternative.
- It is simple to use. If you are migrating languages you'll find many similarities with respect to SQL Server Development Studio or MySQL Workbench.
- Its performance is good. You will not be [waiting] long before you run a query or [have to] get used to long waits.
- The learning curve is almost direct.
- If you already use Oracle SQL Developer, you could expect some delays or a learning curve in finding all the options.
- You need to get a license.
- It can be somewhat heavy compared to tools among other areas.
- It's a wonderful tool to get any kind of relational data from tables, apply filters, test examples, Maintain the database, control the users.
- It can give you statistics of use, bottlenecks, etc.
- It lets you develop and test your own queries and/or PL programs. You can even optimize both of them.
- It is only available for Windows. I would like to use it on Linux or even Apple environments but it's not possible right now.
- Browse Database Object
- Run queries
- Admin activities
- Visual Explain plan
- More options for explaining plan
- Little easier to find data in query results
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.
Toad was used by different teams within our project and was suitable for users of all skill levels:
- Database development team: For end-to-end database development.
- Database support team: For fixing bugs in code logics within procedures and functions and for monitoring day to day jobs.
- Database Administrator: For administering database and automating code analysis, performance analysis etc.
- Business Intelligence/ Reporting team: For Analysing SQL logics and comparing database vs. report logic and output.
- QA team: For creating test data and validating various functionalities.
- Front-end team : For verifying database objects that are linked to front-end application.
The business problems which we solve using Toad are Data cleanup, everyday monitoring the database and doing modifications in the database, if needed.
- It provides excellent platform for writing database queries and executing them and at the same time managing the complete database. It is beneficial for everyone from DBA to SQL developers.
- Its main strengths include in the functionalities such as Script execution, Generating ER diagrams, Evaluating Queries and Query plans, Generating Schema Doc, Importing & Exporting results of queries and Reverse Engineering.
- It has the capability to show the statistics related to time taken by a query to execute completely and finally how many records have been retrieved from that query.
- It allows me to view different type of packages present inside any database scheme easily and then allowing export of queries into csv or excel files.
- Since it doesn't offer a very large buffer size, it will not be beneficial when you need to retrieve millions of rows from a query. So, it is not beneficial for executing very large queries.
- It has a slow performance when you execute a query which will retrieve large number of rows and thus you could only process a fixed amount of information at a particular time using Toad.
- It doesn't provide any script history to view your previous queries which you have executed in Toad. I would like this feature to be added in Toad.
- We use it for develop and debug many of our custom and integration applications throughout IT. It has many options to display and export the results. The result was also fast. It doesn't crash easily like Oracle SQL Developer.
- We also use it monitor databases. There are couple of views, such as Session Browser, that we use frequently. But it needs to be customized to display the information we use really want. Once it's set up, we can see all the queries, top events, long ops, block locks on each session, and take action if necessary.
- It's easy to see all objects. There is a function - Schema/Object Comparison - which I like, to compare and a particular list of objects between two similar databases. And it will automatically list all differences and generate a sync script.
- The user interface can be improved. As a DBA, there are times we need to have different sessions open to different databases. And if we open an Editor, and Schema Browser for each database, it becomes very confusing after a while to see which window is for what database. I think the problem is with the tabbed interface. Their dual tabbed interface can definitely be improved to streamline things to ensure which window is for what database.
- The Session Browser can be improved. Out-of-the-box views have too many columns hidden, and apply some default "group by" columns which I don't find useful. It's hard to set up the view to see exactly the way you wanted. I think color coding the sessions between Active/Inactive/Killed (similar to the view in DBArtisan) will be helpful.
- The default interface is too cluttered, too busy. I don't need/use nearly half of those buttons, and I would imagine most people don't need those buttons either. Again, I have to do some customization to hide those things to make it the way I wanted to be. I wish there was an easier way, for example, just show the buttons relevant to a developer, or DBA, but not both.
- Allows for modifying table data
- Performs powerful, complex commands by clicking a single button
- Offers tools for running complex scripts on tables and exporting for reports
- There is a steep learning curve to use the software
- Slightly expensive
- Can cause significant damage to your databases if you are untrained
Toad for Oracle Scorecard Summary
Feature Scorecard Summary
What is Toad for Oracle?
Toad for Oracle Competitors
Toad for Oracle Pricing
- Does not have featureFree Trial Available?No
- Does not have featureFree or Freemium Version Available?No
- Does not have featurePremium Consulting/Integration Services Available?No
- Entry-level set up fee?No
Toad for Oracle Technical Details