Oracle SQL Developer Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
Real User
Infrastructure Principal at a tech company with 10,001+ employees
Sep 29 2016

What is most valuable?

They've done so many things that have made that product just so great. The most valuable features, what I tend to now use the most, outside of the change they've made in the IDE itself, are how it's become more flexible and the maturity in... more»

How has it helped my organization?

When I was reviewing some things in SQL Developer, one of the things that jumped out at me, especially in a former job a couple years ago, was the Cart feature. It allowed you to really streamline processes. Our process before was my... more»

What needs improvement?

There are always areas of improvement as it relates to the tool's ability, the process that you need to go through in order to connect to some of the non-Oracle databases. You've got to go find the drivers for connecting to a DB2 database or... more»
Real User
Database Development Engineer at a government with 1,001-5,000 employees
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 create report definitions in different layouts... 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, four-step wizard and all the data will be in your... 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 is the same. It's an HTML+ flash type of report that both products allow to save. The part... more»
Find out what your peers are saying about NetBeans vs Oracle SQL Developer and others in IDE.
291,145 professionals have used our research since 2012.
Real User
Founder & Oracle Database Consultant / Trainer at RebellionRider.Com at a tech consulting company with 51-200 employees
Feb 22 2017

What is most valuable?

This open-source GUI is feature-rich software. If I have to choose one most valuable feature, then I will definitely go with the Data Modeler feature. Modeling the structure of all the data and database objects along with their attributes has... more»

How has it helped my organization?

As a database trainer, I would like to say that although SQL developer is an open-source software, yet it provides a lot of features that you can find only in paid versions of its counterparts. It is lightweight; hence, it takes up less... more»

What needs improvement?

While working with Data Pump, I have faced a few problems. For example, sometimes it won’t let me change the set file type. Although this was not that big of an issue, yet I think that the Data Pump feature could be further improved.
Consultant
Senior Database Consultant at Performing Databases
Jun 29 2018

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 it provides.

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 multiple projects so I don't have to have a different approach for... 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, which ones are hanging; and it would be great to make them independent... more»
Real User
Assistant Director, Applications Development Services in the Student Collaboration Center at Temple University
Feb 17 2017

What do you think of Oracle SQL Developer?

Valuable Features The code editor The tree view The debugger The support available for the product • Improvements to My Organization Because I work in higher education, and budget dollars are always limited, the fact that this product is delivered at no cost to us as Oracle users is phenomenal. Only a small fraction of our in-house staff are using another solution to write code that affects our student information system (SIS). IT staff supporting the SIS could not do our jobs without SQL Developer. • Room for Improvement Since the upgrade to 4.1.5, I have noticed improvement in functionality. I'm not freezing up any longer. • Use of Solution I have used it since 2011. • Deployment Issues Deployment is VERY easy. We even have non-tech, functional users installing...
Real User
Oracle Developer at Freelancer
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 open-source and many small customers don't need all the super... 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 not work. Something in the Java was not compatible. I would have... more»
Real User
Manager - Technical at Molina Healthcare
Nov 30 2016

What is most valuable?

I would say the number one feature is it’s easy to use functionality. It is an extremely simple product and the UI is user-friendly.

How has it helped my organization?

We use it for JD Edwards to SQL the queries on the SQL database side, so it gives us the results fast. In this way, we are able to help the business. The process is that once we run it to get the results, we can optimize it and send them out... more»

What needs improvement?

One of the options that I would like to see is the cloud solution module last year. We took out the HR part from JD Edwards and moved it into the cloud. That is one of the features that I would like to see, if there is some integration... more»
Real User
Senior Partner at a manufacturing company with 1-10 employees
Aug 22 2018

What do you think of Oracle SQL Developer?

Primary Use Case I use the product, and the many aspects of it, because it covers everything from querying a database to monitoring to making a conceptual model to getting the model from the database and producing diagrams. It has many uses. • Improvements to 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 will be done. • Valuable Features 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. • Room for Improvement There is room for improvement in the Real Time SQL Monitoring. • Use of...
See 16 More Oracle SQL Developer Reviews

Articles

User Assessments By Topic About Oracle SQL Developer

Find out what your peers are saying about NetBeans vs Oracle SQL Developer and others in IDE.
291,145 professionals have used our research since 2012.

Oracle SQL Developer Questions

Oracle SQL Developer Projects By Members

Oracle SQL Developer Consultants

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


Sign Up with Email