Oracle SQL Developer Reviews

4.4 out of 5 stars
 (20)
Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
034198de ff65 441f 9193 00f220bbbb23 avatar
Real User
Infrastructure Principal at a tech company with 1,001-5,000 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»
3165bcb8 e56a 4173 b5f2 19932495e035 avatar
Vendor
Senior Technical Evangelist at Snowflake Computing
Aug 18 2016

What is most valuable?

To me, the most valuable feature is the ability to quickly reverse engineer a database structure into a data model. There's also a drag-and-drop feature that helps you build queries in SQL Developer, which has a visual query builder with it. I like that feature a lot as it has a number of options in the wizard to pick what type of query you're trying to build.... more»

How has it helped my organization?

Where clients of mine have adopted using the data modeler in particular, the teams are able to become more efficient because they have the data model to use as a reference diagram and documentation to the structure of the database. That made planning changes to the database, reports and things like that much easier to do, and less error prone. Whereas before,... more»

Have A Question About IDE?

Our experts can help. 270,647 professionals have used our research on 6,265 solutions.
Anonymous avatar x80
Real User
Sr. Team Lead, Enterprise Platform Solutions at a hospitality company with 1,001-5,000 employees
Aug 18 2016

What is most valuable?

I've actually been using a similar tool for probably 17 years, but we switched over about four years ago to SQL Developer. A lot of these features I had used previously but there are advantages to SQL Developer. I guess just cleaning the... more»

How has it helped my organization?

The biggest thing is really the cost savings as opposed to using a competitor project or competitor application to SQL Developer. The competitors cost significantly more. Since Oracle SQL Developer is free, we no longer incurred the cost of... more»

What needs improvement?

There are a lot of options and I think, as with any tool, making finding those options the easiest would be something that that this tool could work on. Sometimes it kind of takes a while to go through and remember where different options... more»
394802ba 5c90 46a4 a95f e9ae0cb57831 avatar
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»
04d405f8 4f37 45e6 b974 64e1ee34ee75 avatar
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.
See 15 more reviews

Articles

User Assessments By Topic About Oracle SQL Developer

Have A Question About IDE?

Our experts can help. 270,647 professionals have used our research on 6,265 solutions.

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

Vendor 7751 screenshot 1524945170

Sign Up with Email