Oracle SQL Developer Pros and Cons

Oracle SQL Developer Pros

Martin Klier
Senior Database Consultant at Performing Databases
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.
It's easy to deploy, I can copy it onto the system and run it without having to install it and this makes it a very good solution for quick use.
View full review »
Carlos Thomas
Senior Partner at a manufacturing company with 1-10 employees
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.
View full review »

Oracle SQL Developer Cons

Martin Klier
Senior Database Consultant at Performing Databases
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 from each other.
Scalability has room for improvement. Often if you have to do a heavy load of queries or are getting large result sets you have to be careful not to overload the Java virtual machine that's running.
View full review »
Carlos Thomas
Senior Partner at a manufacturing company with 1-10 employees
There is room for improvement in the Real Time SQL Monitoring.
It's more stable sometimes and less stable other times. I have used it in Windows, Mac, and Linux. It's variable, it's not the same stability. I think that can be improved on.
View full review »
Find out what your peers are saying about Oracle, Eclipse Foundation, Devart and others in IDE. Updated: July 2020.
430,376 professionals have used our research since 2012.