Most Helpful Review
Find out what your peers are saying about Eclipse Luna vs. Oracle SQL Developer and other solutions. Updated: September 2019.
372,906 professionals have used our research since 2012.
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
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.
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.
I have a lot of flexibility with it.
The newer version has a lot of new features. It generates output and scripts for your Ultrix. It can generate JSON, XML, etc.
You do not have to install it, just dump it on the OS, then use it.
Ability to analyze performance, using Explain Plan statement.
Using execution plan, I am able to do lots of query tuning.
Toad has a lot of features that are very useful, fast, and well developed.
The best product for working with Oracle databases for support, checking and loading data.
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.
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.
I would like it to support background processes better.
If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager.
The competing products have more features.
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.
I would like to see an improvement in the performance because opening the browser and the editor should be faster.
There may be an issue with processing limitations but this cannot be confirmed as a problem with the product or with the newest releases.
Many users don't know how to add licensing to Toad, or where it is shown, so they could make that easier.
Pricing and Cost Advice
It has the advantage that it's free. The next best competitor would cost several thousand dollars.
It is basically free.
It's a free tool.
In my opinion, this solution is a little expensive, but I understand that good programs cost more money.
There are paid and free-for-use versions of the product.
out of 9 in IDE
Average Words per Review
out of 49 in Database Development and Management
Average Words per Review
Compared 84% of the time.
Compared 4% of the time.
Compared 3% of the time.
Compared 60% of the time.
Compared 6% of the time.
Compared 5% of the time.
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
Toad Data Modeler helps you create high-quality data models. This data modeling tool enables you to easily deploy accurate changes to data structures across more than 20 different platforms.
Learn more about Oracle SQL Developer
Learn more about Toad
Information Not Available
Comms Service Provider22%
Financial Services Firm11%
Financial Services Firm18%
Software R&D Company16%
Comms Service Provider10%