Chart Key
Average Rating
Average rating based on reviews
Views
Number of total page views
Comparisons
Number of times compared to another product
Reviews
Total number of reviews on IT Central Station
Followers
Number of followers on IT Central Station
The total ranking of a product, represented by the bar length, is based on a weighted aggregate score. The score is calculated as follows: The product with the highest count in each area gets the highest available score. (20 points for Reviews; 16 points for Views, Comparisons, and Followers.) Every other product gets assigned points based on its total in proportion to the #1 product in that area. For example, if a product has 80% of the number of reviews compared to the product with the most reviews then the product's score for reviews would be 20% (weighting factor) * 80% = 16. For Average Rating, the maximum score is 32 points awarded linearly based on our rating scale of 1-10. If a product has fewer than ten reviews, the point contribution for Average Rating is reduced (one-third reduction in points for products with 5-9 reviews; two-thirds reduction for products with fewer than five reviews). Reviews that are more than 24 months old, as well as those written by resellers, are completely excluded from the ranking algorithm.

IDE Reviews

Read top reviews of IDE solutions from the IT Central Station community:
Your trust is our top concern, so companies can't alter or remove reviews.
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»
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. 279,728 professionals have used our research on 6,322 solutions.
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»
Consultant
Senior business Intelligence consultant at Asociación SevillaUP
Jul 04 2016

What is most valuable?

Source Control with SVN and Git(Hub)Code beautifier and completion Schema and data synchronization. https://www.devart.com/dbforge/sql/studio

How has it helped my organization?

We moved from 3 month releases to 1 month release for updates to the production database, using a combination of improved processes, simplification of paperwork and -last but not least- strict source control on the T-SQL code repository... more»

What needs improvement?

I would really like to have this software as cloud based SaaS with seamless integration to GitHub so that I don't have to reinstall everything each time I move to another client. This tool is only for SQL Server, but Devart has similar... 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»
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 06 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»
Consultant
Senior OBIEE Consultant at a tech consulting company with 51-200 employees
Aug 04 2016

What is most valuable?

For the last few years: Ctl + F7. That shortcut will format my queries the way I desire. This is especially helpful since I work with a query generator and sometimes have to look at hundreds of lines of SQL. Formatting it helps me read the... more»

How has it helped my organization?

At a prior organization, we had no reporting capabilities. Business Users would ask me to run reports for them. Since there were restrictions in other delivery mechanisms (think: web front end), I ended up creating SQL Developer Reports and... more»

What needs improvement?

Feature-wise, it has everything that I need. My only complaint over the years has been memory usage, which seems to improve with each release. I also understand that this may be out of the developer’s control.
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»
Oracle
Consultant
Senior Software Engineer at a tech company with 201-500 employees
Aug 30 2017

What is most valuable?

* Linux native makefile support * Simple setup * Free * Multi-project support * C++ 11 support (for a long time) * Simple project configuration

How has it helped my organization?

I use Vim for all small code changes, but I prefer using IDE for the following operations: * When I want to work on large new code, and to move/copy code from file to file more quickly. * Debugging. * Project configuration, compiler flags,... more»

What needs improvement?

Debugging: Watches, Evaluate Expression, and data inspection are limited. Memory: Still uses a lot of memory, and a little slow before starting a run or debug session. UI: Some bugs (buttons are not the same, missing edit buttons in some... more»
Real User
Senior Level 2 Software Engineer at Akamai Technologies
Oct 16 2016

What is most valuable?

The most valuable features are being able to see all of the database objects – every single one of them – within each schema; being able to edit them; and being able to create objects. My whole job is done in there.

How has it helped my organization?

The solution I've created is revenue forecasting and our organization goes to Wall Street with the earnings call, with the forecast. So it's very valuable to the finance department.

What needs improvement?

I would say the layout should be improved. I've also have used PL/SQL Developer, and I like the layout, the landscape, of that application better than SQL Dev. Even though, in SQL Dev, you can highlight every single view and save the DDL,... more»
Oracle
Real User
System Architect and NetBeans Dream Team Member at a tech vendor with 501-1,000 employees
Aug 31 2017

What is most valuable?

One of the most important features is that Apache Maven supports it. Basically, you can open any Maven project in IDE without any additional configuration.

How has it helped my organization?

For the user who chooses to use it, they can start to work on the company's projects as soon as the IDE is up and running. No additional configuration is needed, just checkout projects from the VCS server and open it.

What needs improvement?

One of main areas that the tool can improve is performance. As with any tool, there are some use cases for which improvements would be welcome.
Consultant
Principal and Owner at Sandwich Analytics
Nov 15 2016

What is most valuable?

In my work in BI development I find that Oracle SQL Developer is the main tool in my tool box. I can use it in so many ways: When I am designing a solution the ability to reverse engineer and diagram a database is an enormous boost to my... more»

How has it helped my organization?

SQL Developer has allowed me to produce excellent system documentation, rapidly optimise query performance and allowed me to create top-quality source and object deployment methodologies.

What needs improvement?

The GUI ‘navigator’ screen uses different icons for partitioned, indexed organised tables. temporary and of course conventional tables. This allows users to see at a glance the type of table object in use. This is not the case with indexes in... more»
Consultant
IT Consultant at a tech consulting company with 51-200 employees
Sep 25 2016

What do you think of Oracle SQL Developer?

Valuable Features I noticed that many of the small features are the biggest time-savers like: ‘Copy Selected Column Header(s)’ in the data grid Persistent highlighting of rows or cells in the data grid Search-and-replace with its smart options History (of statements and files) Splitting windows and document groups, pinning Personally, being a nosey person, I love the Statements-Log Window, which shows every command SQL Developer sends to the database. • Use of Solution I have used it for three years. • Deployment Issues Deployment was the easiest I ever encountered: Unzip Optional: find ide.conf, set the language to ‘en’ Optional: change NLS settings Ready • Stability Issues Version 4.1.3 64-bit is very stable. I had some problems with an older version freezing...
Oracle
Real User
Java Developer at a tech vendor with 501-1,000 employees
Jun 04 2018

What is most valuable?

* Java development support. (The Java editor is one of the best Java IMHO editors. Java projects support Ant and Maven.) * RCP support * GUI editor for Java windows * RCP support: An easy way to create your own app using NetBeans base. There... more»

How has it helped my organization?

It has sped up our Java development. Regarding using Eclipse before, creating GUI forms became much faster and as well as the maintenance of them.

What needs improvement?

The background scanning of projects should be optimized after starting NetBeans. When a lot of projects are opened, it takes a little too long for NetBeans to start up. I experienced this with more than 30 projects open. However, after... more»
Real User
Software Architect at a tech services company with 501-1,000 employees
Aug 16 2016

What is most valuable?

Off the top of my head Data Modeler. No PL/SQL IDE has such modelling capabilities, as far as I know. This is a killer feature for me. * Database Export * Database Diff * Debugging capabilities

What needs improvement?

Off the top of my head (I don't use it that often): * Just copy IntelliJ's IDEA for PL/SQL * Projects - there are none and are much needed * More code formatting options * To be able to handle db object scripts that end with / * File browser * Filtering * Favourite locations * Versioning is there, check. But it sucks a lot, double check. Maybe except SVN. It's... more»
Real User
Oracle architect & senior DBA, OBIEE data analytics, warehousing & ETL specialist at a tech consulting company with 51-200 employees
Jul 29 2017

What do you think of Oracle SQL Developer?

Valuable Features Among the most valuable features is the automated unit test capability for PL/SQL development. It allows us to implement a form of test driven development (TDD) for database-resident code. • Improvements to My Organization We can switch between heterogeneous databases. After installing a MySQL driver, for example, we can work with these row stores. It also supports Oracle Cloud legacy schema-as-a-service connections and the newer DBaaS connections. • Room for Improvement I am not aware of any areas for improvement at the moment. • Use of Solution We have been using the solution for eight years. • Deployment Issues We did not encounter any issues with deployment. • Stability Issues There are occasional runtime issues that are easily...
Consultant
Senior Consultant at Contracted by Siemens
Jun 06 2018

What do you think of Oracle SQL Developer?

Primary Use Case We use it daily to merge our databases. In my function, I use it as my client database. I am also using a newer version. It is small client, which is new product. We use the GUI product daily. This is my daily tool for whatever I am doing.  • Improvements to My Organization It is very easy to use.  I have a lot of flexibility with it.  For DBA tasks, it is also very good. • Valuable Features 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.  • Room for Improvement The competing products have more features.  • Stability Issues It is stable. There are no problems. It is a client. • Scalability Issues It is just client. It does not really matter....

Have A Question About IDE?

Our experts can help. 279,728 professionals have used our research on 6,322 solutions.
3,540
TOP 10POPULAR
Senior business Intelligence consultant
Freelance MicroStrategy Professional. Author of the book: "Business Intelligence with MicroStrategy" I've been doing Business Intelligence projects with MicroStrategy and SQL Server/Oracle for the last 10 years now. I have experience in several sectors including Healthcare, Agriculture and... more>>
1,230
Principal and Owner
"A highly talented and experienced Business Intelligence and Data Warehousing consultant with the ability to cross the divide between technical and business consulting" I have a great passion about data and its value to a business; this is reflected in my blog writings and conference... more>>
Reviewed Oracle Data Integrator (ODI): I can readily develop processes that use relational,...

Sign Up with Email