Toad for Oracle Reviews

I used Toad for Oracle for two years when I was lead Oracle 10g database administrator, during which I worked on the Nigerian census 2006 results and migrated the database into the National Population Commission GeoPortal RDBMS database.

My main use case for Toad for Oracle involved writing codes to transfer test data from a test environment on a virtual server where an RDBMS 10g database instance was installed to try the data management and data behaviors of approximately 120 million records. I used Toad for Oracle for debugging, writing codes, troubleshooting, and running the codes to ensure everything was functioning correctly in the test environment before porting and migrating it into the production live environment.

I personally believe Toad for Oracle is a fantastic software for Oracle PL/SQL developers, giving developers the window with tools and the platform to write fantastic codes to link up with databases. I have nothing but praise for Toad for Oracle.

When I used Toad for Oracle, it gave me the opportunity to debug my codes, test-run them, and use an architectural algorithm masterpiece to review my codes and understand whenever the codes executed and found bugs, what happened, where it happened, and why it happened. That provided me with signposting and understanding of how to better structure my codes, improving my productivity, creative and critical thinking skills, time management on tasks, and providing an exceptional interface for Oracle PL/SQL developers. Toad for Oracle is a wonderful tool for Oracle PL/SQL developers and for Oracle database administrators.

The user interface of Toad for Oracle is excellent, and I love it the way it is, with no further challenges or comments for improvement.

Toad for Oracle helped save errors and reduce time for critical activities. It reduced the debugging of codes written to test data of up to 120 million records by approximately 75 percent.

I think Toad for Oracle should create an academy for training youngsters on how to code and debug using the Oracle PL/SQL extension plugin and make it more intuitive, probably using gamification, because people learn differently. Some are kinesthetic learners, some are audio learners, some are visual learners, and some are audio-visual learners. Having a gamification aspect on Toad for Oracle where it explains how to code, debug, and gives young starters or new starters confidence and understanding of what to do and how to do it would help ensure that those wanting to get into coding have that flair, making them able to engage with using it effectively.

I have been working in my current field for approximately 14 years.

Toad for Oracle is stable.

Toad for Oracle's scalability is one of the best, if not the best, in the market.

The customer support for Toad for Oracle is excellent.

I rate the customer support of Toad for Oracle a 10 on a scale of 1 to 10.

I previously used SQL Server, which was standalone software per instance and not viable for solving debug problems related to big data of approximately 120 million records. My team faced many debugging challenges, but Toad for Oracle easily handles the scale and complexity of big data.

Before choosing Toad for Oracle, I evaluated SQL Server, PostgreSQL, and MySQL. My experience with SQL Server led me to believe Toad for Oracle was the best choice because it can be used on any database instance, not just Oracle, and its extended capabilities made it the right decision.

I have seen a return on investment with Toad for Oracle, with time saved at 75 percent, productivity increased by 60 percent, the distribution, manipulation, and presentation of data increased by 50 percent, and streamlined workflows improved by 40 percent. Productivity increased across all departments, making it truly a win-win.

I did not directly get involved in the pricing, setup cost, and licensing of Toad for Oracle; I only provided my recommendations to the procurement team. However, a comparable cost analysis was conducted, justifying the business case for purchasing Toad for Oracle, and the benefits outweighed the investment, aligning with our strategic and operational objectives. Overall, it was a good investment for the business.

My advice for others looking into using Toad for Oracle is to use the starter packs and how-to guides, discuss with customer support to tailor solutions for their needs, and engage in reading and understanding the software and its services. Overall, Toad for Oracle is a very effective management and quality control tool, essential for any organization looking to make serious strategic inroads and decisions for profitability.

I think there needs to be more information and marketing improvements targeted at the audience to ensure Toad for Oracle becomes globally known. I believe it is one of the best tools in the market, but many people might not be aware of it. Enhanced sensitization, awareness, and marketing are necessary, especially among students in Information Technology and Computer Science, by providing free software licenses for projects to increase awareness about this outstanding product.

I rate this review a 10 out of 10.

I have been working for two and a half years in my current field, primarily as a full stack developer building and maintaining enterprise applications using Java, Spring Boot, Angular, REST APIs, SQL and PLSQL. I have also been working extensively with Oracle databases and Toad for Oracle has been one of my primary tools for database development, debugging and data analysis throughout my career.

I have been using Toad for Oracle for about two and a half years. It is one of the tools I use almost every day for Oracle database development. I primarily use it to write and execute SQL queries, develop and debug PLSQL procedures, functions and packages, validate data during development and troubleshoot database related issues over time. It has become an essential part of my daily workflow because it makes database development and analysis much more efficient.

Our organization mainly focuses on a payroll processing project and we use Toad for Oracle for our entire project, where my primary use case is Oracle database development and troubleshooting. I use Toad for Oracle every day to write and execute SQL queries, develop and debug PLSQL procedures, functions, packages and validate data during feature development and bug fixes.

A recent example was while working on an enhancement related to our application payment processing module. After implementing the application changes, I used Toad for Oracle to verify that the correct records were being inserted and updated across multiple Oracle database tables. I wrote SQL queries to compare the before and after data, executed PLSQL blocks to test different scenarios and checked package outputs to ensure the business logic was working correctly. I also used Toad for Oracle to debug stored procedures, review execution plans where a query is running slower than expected and quickly navigate between database objects including tables, views, packages and triggers. Having all these capabilities in one tool makes it much easier to investigate issues and validate changes without constantly switching between different applications.

Toad for Oracle is integrated into almost every stage of my database related work, whether I am developing a new feature, fixing a production issue or validating a deployment. It is usually the first tool that I open. I particularly appreciate that I can manage multiple database connections simultaneously, save frequently used SQL scripts and quickly compare data across environments. It also makes it easy to inspect database objects, review the package code and export query results when I need to share findings with teammates or other business people. Overall, it has become an essential part of my daily development workflow because it helps me work more efficiently and reduces the time spent on routine database tasks.

Many features stand out to me in Toad for Oracle. The feature that I use the most is the SQL editor. It is fast, supports syntax highlighting and auto completion and makes it easy to write, test and execute complex SQL queries and PLSQL blocks. The formatting is very good. The DBMS output is also very clear. Another feature I rely on is the schema browser. It lets me quickly navigate tables, views, packages, procedures, functions and triggers without having to remember object names, which saves a lot of time because in our application, we use a very large application throughout our organization. Using the schema browser helps me to quickly navigate between all these elements including tables, views and packages. I also frequently use the DBMS output window and debugger when troubleshooting PLSQL code. They make it much easier to understand how a procedure or package is executing and identify issues before deployment. Finally, I appreciate the ability to manage multiple database connections. I can connect to the development environment, QA environment, staging environment, as well as production environment simultaneously. I can manage multiple database connections and export query results into Excel or CSV whenever I need to share data with my teammates, other teams or business users.

If I had to pick one feature I cannot live without, it would be the SQL editor, because it is the part of Toad for Oracle that I use constantly throughout the day, whether I am validating data, investigating a production issue, testing a query or developing real SQL code. Almost everything starts in the SQL editor for me. What I appreciate most is that it allows me to quickly execute queries, work with large scripts, view results immediately and switch between different database connections without interrupting my workflow. As for improvements, I would appreciate a more modern user interface and smarter assistance for query optimization. For example, it would be helpful if Toad for Oracle could proactively suggest query performance improvements or highlight potential issues before execution. Better integration with source control systems would also make collaboration easier for teams that manage database code through Git based workflows. Overall, the SQL editor is the feature that delivers the most value to me on a daily basis and is one of the main reasons I continue to use Toad for Oracle.

One additional feature I really appreciate is the session management. Being able to save connections, reopen previous workspaces and organize SQL scripts makes it easy to pick up where I left off, especially when I am working on multiple tasks in parallel. Looking ahead, I would love to see more AI assisted capabilities, for example, generating SQL query suggestions, explaining execution plans in plain language or recommending optimizations for PLSQL code. These kinds of features could help developers troubleshoot issues more quickly and improve productivity. Toad for Oracle already provides a comprehensive set of database development tools and it has been a reliable part of my daily workflow.

Toad for Oracle has had a positive impact by making our database development and troubleshooting processes much more efficient. Since it is the primary tool our developers use for Oracle database work, it has helped standardize how we write, test and validate SQL and PLSQL code. One noticeable improvement is that we can investigate database issues much faster and when a bug is reported, we can quickly query the data, review stored procedures, validate business logic and identify the root cause without switching between multiple tools. It has also reduced the time required for data validation during feature development and deployments. Before promoting changes, we use Toad for Oracle to verify that the expected records are inserted or updated correctly, which helps catch issues early and increases confidence before the releases. Overall, it has improved developer productivity, simplified database maintenance and helped us deliver database changes with greater accuracy and fewer manual errors.

In terms of productivity improvements, it saves me around twenty to thirty percent of the time on activities including writing and testing SQL queries, debugging PLSQL, validating data after deployments and investigating production issues. Having features including the schema browser, SQL editor and debugging tools in one place reduces context switching and speeds up problem resolution. A practical example is when we troubleshoot production issues. Instead of manually looking through different databases and database objects or using multiple utilities, I can quickly navigate to the relevant packages, execute queries, verify the data and identify the root cause much faster. This has reduced turnaround time for database related issues and made our development and testing processes more efficient. While we have not measured a reduction in defects with formal statistics, having better visibility into the database before deployment has helped us catch data related issues earlier, resulting in fewer rework cycles.

Overall, I am very satisfied with Toad for Oracle, but there are a few areas where it could improve. First, the user interface feels a bit dated compared to some newer database tools. A more modern and customizable UI would make the experience more intuitive, especially for new users. I would also appreciate seeing more AI powered capabilities such as intelligent SQL optimization suggestions, automatic explanations of execution plans and recommendations for improving PLSQL code quality. Another area is source control integration. While it supports version control, a smoother and more seamless Git workflow would make collaboration easier for teams managing database code alongside application code. Lastly, performance when working with very large scripts or large result sets would further improve the overall experience. None of these are major issues but they would make an already strong product even better.

One additional improvement I would appreciate is better onboarding for new users. Toad for Oracle has a lot of powerful features, but many of them are not immediately discoverable. More interactive tutorials, guided workflows or built in tips would help new developers become productive more quickly. I would also appreciate more customizable dashboards where I could pin frequently used database objects, saved queries or performance metrics based on my daily work. As more development teams adopt AI assisted workflows, having built in AI features for explaining complex PLSQL code, summarizing database objects or generating documentation would be a valuable addition. These enhancements would improve usability while keeping Toad for Oracle's core strengths intact.

In my experience, Toad for Oracle has been very stable. I use it daily for writing SQL queries, developing and debugging PLSQL and validating data and it has been a dependable tool throughout that time. I rarely experience crashes or unexpected behavior even when working with large scripts or multiple database connections. It generally performs well. Most of the issues I have encountered have been related to database connectivity or the Oracle environment itself rather than Toad for Oracle. Overall, I would describe it as a reliable and mature product that is well suited for enterprise Oracle development.

In my experience, Toad for Oracle scales well for enterprise environments. While it is a desktop client, it handles connections to large Oracle databases and complex schemas without any major issues. In our environment, we work with large data sets, numerous database objects and multiple developers accessing the same Oracle environments. Toad for Oracle has been able to handle complex SQL queries, PLSQL packages and large schema reliably. From a user perspective, I have not noticed scalability being a limitation as long as the underlying Oracle database performs well. Toad for Oracle remains responsive and continues to support day to day development, debugging and data analysis effectively.

I have not had many occasions to contact Quest support directly because Toad for Oracle has been quite stable in our environment. Most day to day questions are answered through the product documentation or by our internal database team. On the few occasions where support was involved through our organization's IT team, the experience was positive. The responses were professional and the issues were resolved in a reasonable timeframe. I also found the documentation and knowledge base to be comprehensive, which often made it possible to resolve questions without opening a support case. Overall, based on my experience, I would rate the customer support eight out of ten.

Toad for Oracle has been the primary Oracle development tool in my current organization since I joined. That is what I have been using for my day to day work. I have used command line tools and Oracle SQL Developer for basic database tasks in the past, but for enterprise development, Toad for Oracle provides a much richer feature set than SQL Developer. The advanced SQL editor, schema browser, debugging capabilities, session management and productivity features make it much better suited for the complex Oracle database work we do on a daily basis. That is why it has remained our preferred tool.

As an end user, I was not directly involved in the purchasing or licensing decisions. I cannot comment on the exact pricing or setup cost. From my perspective, the setup was straightforward because our IT team provided the installation package and configured access to the required Oracle environments. Licensing has been managed centrally by our organization and I have not experienced any issues related to activation or license management. Given how extensively we use the tool for Oracle database development and troubleshooting, it has provided good value for our team's day to day work.

There is no other relationship for my company with Quest other than as a customer.

From my experience, it saves me around twenty to thirty percent of the time on activities including writing and testing SQL queries, debugging PLSQL, validating data after deployments and investigating production issues. Having features including the schema browser, SQL editor and debugging tools in one place reduces context switching and speeds up problem resolution. It has not reduced the number of people needed, but it has certainly improved developer productivity and helped us resolve database related issues faster. For a team that works on Oracle databases every day, that translates into quicker development cycles and less time spent on manual investigation.

From discussions within the team, Oracle SQL Developer was a commonly known alternative for basic Oracle development tasks. However, Toad for Oracle was preferred because of its richer feature set for enterprise development, particularly its debugging tools, schema browser, session management and overall productivity features for developers working extensively with Oracle databases.

My advice would be to invest some time in learning Toad for Oracle's advanced features rather than using it only as a SQL editor. Many developers initially use it to run queries but tools including schema browser, PLSQL debugger, explain plan, session management and code navigation can significantly improve productivity. I also recommend organizing frequently used SQL scripts and taking advantage of features including saved connections and workspaces. These small practices save a lot of time if you are working with Oracle database every day. Finally, if you are working in small Oracle ecosystems extensively, Toad for Oracle is well worth considering because it is a mature and reliable tool that supports the entire database development life cycle from writing and testing SQL to debugging, data validation and performance analysis. I would rate this product nine out of ten overall.

My main use case for Toad for Oracle is accessing data in Oracle and building PL/SQL database objects, packages, procedures, and functions.

A quick specific example of how I use Toad for Oracle in my day-to-day work is calculating financial forecasting with multiple data sets through Oracle and building out a process using an Oracle job, procedures, and views to calculate a forecasted contract amount project.

In the past 20 years, I have used it almost every day.

The best features Toad for Oracle offers are the ability to access the database objects and see them in a very simplified manner.

The simplified view helps me in my work as it makes troubleshooting easier.

Toad for Oracle has positively impacted our organization because our financial forecasting data set is trusted throughout the company because of the ability for us to debug and analyze the data with Toad for Oracle.

This trust in the data set has affected business decisions and efficiency by creating a completely separate data department because of the value that we saw with our data because of how we were able to organize and extract data from Oracle with Toad for Oracle.

Toad for Oracle can be improved by working with Microsoft Fabric.

I have been using Toad for Oracle for 20 years.

Toad for Oracle is stable in my experience.

Toad for Oracle's scalability has not really kept up with my organization's growth or changing needs.

Scalability falls short for my organization because from a scalability perspective, the software sometimes seems bloated when installing it on a new machine, and it would be nice if we could reduce the amount of features we are actually installing and keep it streamlined for our current needs.

I have never had to call customer support for Toad for Oracle, so I cannot speak to that experience.

Negative

My experience with pricing, setup cost, and licensing for Toad for Oracle was seamless and I did not encounter any issues.

I have not seen a return on investment, as we have not had a reduction of staff because of the software.

My advice for others looking into using Toad for Oracle is to download it.

My company does not have a business relationship with this vendor other than being a customer.

Toad for Oracle is the only software that I have used consistently for the past 20 years.

I rate this product a 9 out of 10.

My main use case for Toad for Oracle is as a tool for Oracle application development. It is a GUI-based tool that we use for managing, developing, querying, monitoring, and administering Oracle databases while simplifying database administration.

A quick specific example of how I use Toad for Oracle in my day-to-day work includes browsing tables, views, procedures, functions, packages, triggers, and indexes without writing SQL.

Toad for Oracle is used as a back-end database for core business applications, and it helps with that.

Resolving performance issues with Toad for Oracle has benefited my organization by helping with faster troubleshooting when something is taking much more time or has performance issues. It provides real-time visibility in the database, active sessions, blocking locks, running SQL, and performance issues.

Toad for Oracle helps my organization save time, reduce errors, prevent downtime, and save money compared to its cost. It helps with faster troubleshooting, which equals less downtime, resulting in reduced system downtime, lower SLA violations, and increased IT productivity. The tool also enables faster performance tuning.

The best features that Toad for Oracle offers include the ability to write SQL queries, execute scripts, test database changes, and troubleshoot application issues.

Toad for Oracle helps with troubleshooting application issues. My process involves identifying slow queries for performance issues, and Toad helps me find which SQL is consuming resources using Session Browser and SQL Monitor.

The best features in Toad for Oracle that I find useful are the Schema Browser and the SQL Editor.

Toad for Oracle could be improved by offering deeper support for Oracle Cloud or hybrid databases, as it is a mature tool.

The learning curve is steep for beginners, and the infrastructure is a bit complex.

Regarding Toad for Oracle's AI capabilities, governance and security are limited. It is not a fully AI-driven tool, but it does have some intelligent features such as SQL optimization suggestions.

The accuracy and reliability of Toad for Oracle's output have drawbacks. There is no AI assistant for natural language queries, no predictive analytics, and no anomaly detection, which means its AI capabilities are minimal compared to modern cloud database tools.

I have been using Toad for Oracle for almost three years.

Toad for Oracle is stable and confirmed to be reliable.

Toad for Oracle's scalability is effective. It does not scale the databases itself but scales as a client tool used to manage large Oracle environments. It scales well in enterprise environments and is widely used in banks, telecom companies, government organizations, and large enterprises.

Toad for Oracle's scalability in my organization is efficient as it handles large databases and increasing workloads effectively.

We have never contacted customer support for Toad for Oracle.

I have not used a different solution before Toad for Oracle. We only use Toad for Oracle and have not switched from anything else.

My experience with pricing, setup cost, and licensing for Toad for Oracle is that the logistics team in our bank follows this, and it is a commercial product.

Before choosing Toad for Oracle, I evaluated other options, but I forgot the names.

My advice to others looking into using Toad for Oracle is that it is powerful, but you should learn SQL basics and Oracle concepts first and not jump directly into advanced DBA tools. This way you avoid mistakes in production. You should also always double-check queries before execution. I would rate this review as 15.

I have been working with Oracle database from the beginning, and I have focused on Oracle solutions throughout my career. Currently, we are working on the cloud version of Toad for Oracle.

We use many features in Toad for Oracle, including writing stored procedures, querying large tables, and performance tuning.

We have used the SQL optimization feature in Toad for Oracle. The SQL optimization feature helps us in tuning queries; through the optimizer, we can generate an explain plan or trace, and we use those features for performance tuning.

We use code analysis insights in Toad for Oracle for debugging and writing test cases, including automatic test cases, which helps us with those tasks.

We automate jobs through Toad for Oracle, which is important in our daily workflows.

Normally we write our own queries in Toad for Oracle; whatever data we need, we have to write our own query and use Toad for Oracle only for executing those queries.

Toad for Oracle could benefit from AI features in future updates where it could help in coding stored procedures.

My overall experience in the IT sphere is almost 22 years, and I have been working with software in my field for that entire time.

I would rate technical support for Toad for Oracle at nine on a scale from 1 to 10.

It is quite easy to implement Toad for Oracle; it is not a problem for us in terms of deployment.

Normally, we create scripts for whatever deployment we have, so we need to deploy those scripts. We either deploy directly in some environments or use GitHub to deploy in others.

No financial benefit has been observed after implementing Toad for Oracle because SQL editors are free, and many free tools are available, while Toad for Oracle is a paid solution. However, in terms of writing code and utilization, it is good.

We do not use version control through Toad for Oracle. Financially, I am not aware of the licensing cost for Toad for Oracle because it is paid by customers. My overall review rating for Toad for Oracle is 9 out of 10.

The main use case for Toad for Oracle is for PL/SQL development and debugging, as well as for SQL query and tuning.

The key features of Toad for Oracle that we are using include quick SQL development for our developers, the ability to make templates, and optimized execution plans.

Toad for Oracle does provide automation options to automate some processes, with optimization capabilities for our consultants. The debugging features are particularly helpful, as developers use scheduled jobs and reports, which provides a kind of automated design that is beneficial for us.

Toad for Oracle helps our developers improve code performance, and they have access to a visual hierarchy or tree for execution plans, which is very helpful for our development team.

We are also doing version control integration with Toad for Oracle, which allows developers to organize versions and visualize them as they develop.

The main benefits that Toad for Oracle provides for the end user are streamlining and visibility into wait events and blocked sessions, so finding problems is very streamlined and this saves time for our developers.

I am not an expert in details regarding Toad for Oracle, so I cannot really provide valuable information on areas for improvement. The pricing and licensing could be a minor improvement if licensing were cheaper, as I cannot tell you the actual price at the moment.

I have been working with Toad for Oracle for 15 years.

I would rate the stability for Toad for Oracle as a nine out of ten, and I did not have any complaints.

I would rate the scalability for Toad for Oracle as a nine out of ten. We are using the classic version in our environment, but I have heard that it is stable on large environments and I think it is also suitable for cloud-native applications.

I would rate Quest technical support as an eight out of ten. I am not sure if those in our team had any complaints or issues, but they are also familiar with Oracle and Quest is a good vendor, so I would give it an eight based on what I have heard.

I can compare Toad for Oracle with SQL Developer, which we are also using with our developers. SQL Developer has the benefit of being free, but for administration and DBA features, Toad for Oracle is better. Toad for Oracle is also better for schema and workflow. As we are really focused on the Oracle stack, this is our expertise.

I know that clients use Oracle Enterprise Manager, but it is more complex than Toad for Oracle. Enterprise Manager is more complex and better for monitoring, but for SQL development, Toad for Oracle is much better from my perspective.

The initial setup for Toad for Oracle is simple and I did not have any complaints. The installation and configuration is not too complex or complicated. We are doing it locally and not in a large enterprise environment, as our main task is local development, so the process is straightforward.

I recommend Toad for Oracle for development. Overall, I give Toad for Oracle a rating of nine out of ten because we have been using it for a really long time.

I'm using Toad for Oracle for administration of Oracle databases.

Two functions in Toad for Oracle are the most useful to me. One is Redo Log Manager, and the second one is Spotlight.

I use Oracle Advanced Optimization or Oracle Tuning Advisor in Toad for Oracle. I have automated many tasks and jobs through Toad for Oracle, and the automation part helps me save my daily time.

Toad for Oracle is very useful, and there is no need for formatting. It just shows data in the grid as expected and as I want. I don't have to go to the prompt if it's a Linux server or something and do some formatting to view the data in a good way. Toad makes this very simple and very quick.

Toad for Oracle makes the day-to-day actions easy and reduces some manual work for me. I don't have to do some commands to do whatever I want to do. I can just do it with Toad by a click. This is the most useful part of using Toad for Oracle.

Toad for Oracle is useful, but I believe it could be enhanced. I think Quest can consider involving AI or adding some plugin like cloud or something in Toad for Oracle. Optimizing the query or doing tuning advisor in a better way could be improved.

I have been working with Toad for Oracle since 2018 or 2019.

I can rate the stability of the product as seven out of ten. The biggest challenge I have with Toad for Oracle by Quest is that sometimes it freezes and is not responding.

I can rate the scalability of Toad for Oracle as eight out of ten.

I haven't contacted Quest technical support, but I could rate technical support as seven or eight.

Toad for Oracle is the most useful software that I can use for Oracle administration from my perspective. The others I don't prefer to use. I'm accustomed to Toad, and no other software has given me the benefit that Toad has.

The initial setup for Toad for Oracle is simple. There is no complexity to it.

I use Toad for Oracle daily. I haven't experienced data visualization in Toad for Oracle yet. I haven't experienced working with Toad for Oracle's code analysis yet, and I'm uncertain if code analysis helps improve code performance. I haven't integrated Toad for Oracle with version control solutions. My overall rating for this product is eight out of ten.

We use Toad for Oracle for various database management tasks, including CRUD operations such as create, replace, update, and delete, and for DDL and DML tasks. We rely on Toad for managing the data structure and monitoring connected users.

Toad for Oracle simplifies the process of managing database sessions, which is particularly useful for database administrators. It allows us to handle sessions that are blocking other processes efficiently by surfing through the session browser and ending problematic sessions.

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. This functionality is critical for efficient database management, allowing administrators to release resources. 

Additionally, its auto SQL tuning feature provides alternatives to optimize and speed up complex queries, thereby enhancing DB and application performance.

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.

We have been using Toad for Oracle for the last ten years.

Toad for Oracle is quite stable and has not presented any major issues in the past ten years. It has been a reliable tool for database management.

Toad is a tool for connecting to the database and does not directly support scalability. It acts as a third-party connection to the databases and does not impact scalability directly.

An alternative to Toad for Oracle could be using SQL Developer, although it doesn't provide as many functionalities as Toad.

The initial setup is straightforward. Quest provides the software download and a license key. Once the license key is input, the service becomes active.

Toad for Oracle provides significant return on investment by improving query performance and reducing DBA workload.

The licensing cost for Toad for Oracle is relatively high, with their license and DPA suite totaling around five thousand dollars.

SQL Developer is another solution. It doesn't offer the extensive features of Toad for Oracle.

Toad for Oracle is a great choice to make database administration stress-free. It aids in revealing errors in SQL queries and guides developers to optimize them. It also provides rollback features for accidental bulk updates and helps in auto-optimizing query performance, which is crucial for reducing response times.

I'd rate the solution ten out of ten.

I use it for developing packages and procedures, as well as running queries. Additionally, I use it for monitoring the DBA setup.

One thing I can say is that it helps identify issues, especially with the Flashback component. In case of an issue, we're able to drill in and pinpoint where the issue is coming from.

It can easily point you to where you need to be looking.

The schema browser is the most valuable feature. The way it presents the objects in our database.

I think one area is being able to use shortcuts, for example, being able to press F5 to run a query or having the ability to seamlessly copy and paste.

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.

In additional features, I would like maybe one for the integration with the ticketing system. For example, if a ticket is raised to resolve an issue, there should be something that I can click on to update the ticket when I'm done.

I have been using this solution since 2011. I am using version 13.

For its performance. So, it's already quite enough with its functions. I would rate stability a ten out of ten. I have not faced any issue with the solution. 

I would rate the scalability of this solution as nine. If you're using Oracle as a database, you can easily add on the additional components for scalability. It's really scalable. You can go to the support server or the prepaid option without any issues.

Around 10 to 20 users are using this solution. It is used daily in our organization. Database administrator and software developer are the key roles involved in using the software.

The customer service and support team is good. They have a responsive support team when you reach out. We mostly communicate through emails, and for specific support needs, we sometimes have to fill out a small form, like when we're transferring licenses to a new machine.

Positive

I'll give it a nine because the setup is really simple. You just click through the information, and it runs smoothly, and you're done.

We handled the deployment in-house. Only one person was required for the process. It took just a few minutes. It has an installer that we run on local machines. Once you run the installer, you're done. The whole process took less than 30 minutes.

For the deployment process, first, we downloaded the installer, then we ran the installation. After that, we applied the license key and set up the DB connections. Then, you are good to go. Other than bug fixes and support, maintenance is not really required.

It has really helped us pinpoint specific areas with issues, which has saved us time troubleshooting. I would rate the ROI around nine out of ten.

I would rate it six, where one is a low price, and ten is a high price. You just pay the fixed price. There are no additional costs. 

It's a good tool out there. I recommend it. Overall, I would rate the solution a nine out of ten. 

I am currently using Toad for Oracle for reporting purposes. In the past, I have used it for Oracle E-Business Suite Financials, and currently, I am using it for Oracle Cloud. While using Toad, I have also worked with SQL queries written in Java.

If I talk about my work-related tasks, using Toad for Oracle minimizes the time required for queries, and its performance is exceptional. I use it for Oracle reporting purposes.

The most valuable feature is performance tuning. It helps to screen time data and extract data which saves cost as compared to other tools. It improves performance and simplifies workflow which I am working on.

Sometimes when I write a query, it gives an unusual error code. Toad for Oracle does not have a particular resolution within the application. Then, I have to search for the code and find a solution. 

I would like Oracle to implement error codes so that we don't have to search for solutions on Google. It would be more convenient if the error codes were included within the application.

I have been using this solution for three years. I am using the latest version.

It is a stable solution.

It is a scalable solution. There are over 500 users in my organization.

I contacted customer support for error codes. Overall, the technical support has been very good. They are prompt and professional, and they resolve issues on time.

Positive

I have experience using various web-based solutions for data analysis and reporting, such as Oracle Financial, SPW, and SDR for Oracle Cloud. However, these applications do not have query-writing capabilities in desktop-based software like Toad for Oracle.

The solution was implemented at the organizational level. It is not difficult to maintain the solution. It is very user-friendly, and anyone can streamline the data.

There has been an ROI.

Toad for Oracle has a relatively high cost compared to other similar tools. It is a costlier affair for anyone using Oracle products.

I recommend that one should have basic query writing skills or experience with SQL. Otherwise, Toad for Oracle has the functionality, and you can see the tutorials provided for running the program.

Overall, I would rate it a nine out of ten. So far, I'm satisfied with all the features, some of which are very good. In terms of performance and other aspects, the application is good.