Oracle SQL Developer Logo

Oracle SQL Developer pros and cons

Vendor: Oracle
4.3 out of 5
292 followers
Post review
 

Oracle SQL Developer Pros review quotes

MK
Sep 30, 2019
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_user657591 - PeerSpot reviewer
Aug 21, 2018
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.
it_user505650 - PeerSpot reviewer
Jul 27, 2017
It allows us to implement a form of test driven development (TDD) for database-resident code.
Learn what your peers think about Oracle SQL Developer. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,246 professionals have used our research since 2012.
it_user809487 - PeerSpot reviewer
Jan 28, 2018
I have a lot of flexibility with it.
it_user530439 - PeerSpot reviewer
Dec 12, 2017
Using execution plan, I am able to do lots of query tuning.
Theodoros Loizou - PeerSpot reviewer
Jul 17, 2022
The most valuable features of Oracle SQL Developer that I use. However, I do not use all of them
it_user756873 - PeerSpot reviewer
Dec 26, 2017
Ability to analyze performance, using Explain Plan statement.
 

Oracle SQL Developer Cons review quotes

MK
Sep 30, 2019
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.
it_user657591 - PeerSpot reviewer
Aug 21, 2018
There is room for improvement in the Real Time SQL Monitoring.
it_user505650 - PeerSpot reviewer
Jul 27, 2017
There are occasional runtime issues that are easily worked around, especially on a Windows deployment.
Learn what your peers think about Oracle SQL Developer. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,246 professionals have used our research since 2012.
it_user809487 - PeerSpot reviewer
Jan 28, 2018
The competing products have more features.
it_user809580 - PeerSpot reviewer
Jan 28, 2018
The stability depends on what version you're using. There are more successful versions and are less successful versions. For example, 17.3 is less successful. There were many bugs. Now, we are trying to pull all the developers to upgrade to 17.4.
it_user530439 - PeerSpot reviewer
Dec 12, 2017
The initial setup is always a problem, it cannot find the Java SDK.
it_user809562 - PeerSpot reviewer
Jan 28, 2018
If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager.
Theodoros Loizou - PeerSpot reviewer
Jul 17, 2022
Oracle SQL Developer could improve the speed, it is a bit slow.
it_user756873 - PeerSpot reviewer
Dec 26, 2017
It would be nice to have the ability to access DBs than Oracle.
it_user809544 - PeerSpot reviewer
Jan 28, 2018
I would like it to support background processes better.