Oracle SQL Developer Reviews
Apr 09 2018
What is most valuable?* The tight integration with other Oracle products and database features/options. For example, you can open data models, and review AWR and ASH reports. * The ability to reuse your own queries to… more»
How has it helped my organization?One of the goals of the tool is to allow the user to complete tasks with the least number of steps. For example, to load an Excel spreadsheet into a table, you just have to complete a simple… more»
What needs improvement?I would like to see the Monitor Sessions functionality to provide access to SQL Monitor reports in the same format used by Oracle Enterprise Manager. That would help developers to see what their SQL… more»
Which solution did I use previously and why did I switch?SQL Developer has reached a maturity level where it offers pretty much the same essential functionality (and much more) that you can find in other solutions, with the benefit of being free. Why not… more»
What other advice do I have?Invest some time on standardizing the preferences/reports and centralize them so that all of your developers use exactly the same setup. For example, you could customize all the preferences that… more»
Which other solutions did I evaluate?I did not evaluate other options.
Sep 30 2019
What is most valuable?I like it because it's very similar in output to SQL *Plus, and it has many convenience features that make it easier to read the data and use the basic reporting features… more»
How has it helped my organization?It makes life easier because I don't need to install something onsite when I am with a customer. And, since it's free, it helps me to unify and streamline my approach over… more»
What needs improvement?I think it would be great to have an overview over the sessions it opens so that we could easily see and control which connections to the database we want to keep open… more»
What's my experience with pricing, setup cost, and licensing?License is free, setup is simple and scriptable.
Which solution did I use previously and why did I switch?I had to decide which solution we would use for a generic approach; and it was SQL Developer, in our case. At first, we worked with non-graphical utilities, command-line… more»
What other advice do I have?I think you should make yourself familiar with this product and get into the core functionality first, before making a decision. I would rate it a nine out of 10 because I… more»
Which other solutions did I evaluate?There are many capable vendors in this category, but since we usually work with Oracle, a product from Oracle was the first choice. In this case, it has the advantage that… more»
Find out what your peers are saying about Oracle, Eclipse, Devart and others in IDE. Updated: January 2020.
389,772 professionals have used our research since 2012.
Aug 22 2018
What is most valuable?You can install it on every platform. It just works. The other thing is that it's free. And Oracle is committed to the development of the tool, so it has been improving.
How has it helped my organization?If you make it the tool you use, everyone can talk the same "language" in terms of the tool and the use cases. Once you know it, how to use it, you can tell the whole organization how a given task… more»
What needs improvement?There is room for improvement in the Real Time SQL Monitoring.
What's my experience with pricing, setup cost, and licensing?It's free.
Which solution did I use previously and why did I switch?Developer is centered on Oracle. I have the need now to monitor a much larger diversity of things. We are talking about monitoring cloud infrastructure where you have machines, where you have many… more»
What other advice do I have?In terms of advice, I would first ask you what you are expecting from the tool and, if it is in the scope of Oracle SQL Developer, I would recommend it. I rate this solution at nine out of 10. It… more»
Jun 10 2018
What is most valuable?Oracle is tremendous. I have always said to everybody, without knowing other databases, that Oracle is the best database that can exist in this world. That's for sure. Everybody is considering cost, mainly, so I've heard many stories recently of migrating to PostgreSQL, for example, because it's… more»
What needs improvement?I tried using SQL Developer once, when I was still working as an employee, using one of the older versions. It worked nicely, and I liked that I didn't need an installation, it was very convenient. But after many years, when I tried to use it again, against the more advanced Oracle Database, it did… more»
Which solution did I use previously and why did I switch?Personally, I always prefer to use a product from Oracle. First of all, this one is free. And second, it is not so complicated. In another company, for example, the strategic development tool was Toad. And they have even joined Toad with a version manager, the specific version manager, and everybody… more»
What other advice do I have?I think it's a good product in the sense that it does not overwhelm you with many features. So I would give it a 10 out of 10. I would recommend it.
Jun 06 2018
What is most valuable?It is easy to use. The newer version has a lot of new features. It generates output and scripts for your Ultrix. It can generate JSON, XML, etc.
How has it helped my organization?* It is very easy to use. * I have a lot of flexibility with it. * For DBA tasks, it is also very good.
What needs improvement?The competing products have more features.
What's my experience with pricing, setup cost, and licensing?It is basically free.
What other advice do I have?Try this if you do not need a lot of storage, especially since it is free and if it is the newer version with no GUI version. Everybody should try it because you do not have to code things to create output from JSON or DDL. It allows you to… more»
Jun 06 2018
What is most valuable?The possibility to connect.
How has it helped my organization?The main benefit of SQL Developer is that it is free.
What needs improvement?There are many additional features I would like to see. The main one would be installation with an installer.
Which solution did I use previously and why did I switch?We didn't have a previous solution but, in parallel, we use Toad; its license is expensive. The important criteria for me when selecting a vendor are good support and an affordable price.
What other advice do I have?Using this solution depends on budget and on the number of developers. The more developers you have, the less you will want SQL Developer.
Jun 07 2018
What is most valuable?It's free.
How has it helped my organization?We have a QA team and we don't want to buy a special product for them just to query the database, so we use Oracle SQL Developer.
What needs improvement?If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager.
Which solution did I use previously and why did I switch?We used to use SQL *Plus, but we needed something with more of a GUI for users who are not technical users. When selecting a vendor the most important criterion is the price.
What other advice do I have?Just try it. It's very easy.
Which other solutions did I evaluate?This was the only free solution we evaluated. And it belongs to Oracle so that was good for us. Toad is much faster to use. It's not Java which takes a lot of time to query and create things. You just… more»
Feb 04 2018
What is most valuable?* It's a free tool * Ability to analyze performance, using Explain Plan statement * Ability to export and import data without using any Oracle utilities
How has it helped my organization?It's a free tool which allows you to see an Oracle Database structure and run queries against Oracle Databases.
What needs improvement?It would be nice to have the ability to access DBs than Oracle.
What's my experience with pricing, setup cost, and licensing?It’s a free tool.
Which solution did I use previously and why did I switch?I have used tools such as Toad, PL/SQL Developer, SQL Navigator. I switched because this one is free.
What other advice do I have?It’s a great tool for accessing and exploring Oracle Databases.
Which other solutions did I evaluate?Toad, SAP ADS, SQL Navigator.
See 4 More Oracle SQL Developer Reviews
User Assessments By Topic About Oracle SQL Developer
Oracle SQL Developer Questions
Read Archived Reviews
What is Oracle SQL Developer?
Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.
For more information on Oracle SQL Developer, visit Oracle.com