Oracle SQL Developer Reviews

Filter by:Reset all filters
industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
rating
Loading...
Filter Unavailable
Galo Balda
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… 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… 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. That would help developers to see what their SQL… more»

If you previously used a different solution, which one did you use and why did you switch?

SQL Developer has reached a maturity level where it offers pretty much the same essential functionality (and much more) that you can find in other solutions, with the benefit of being free. Why not… more»

What other advice do I have?

Invest some time on standardizing the preferences/reports and centralize them so that all of your developers use exactly the same setup. For example, you could customize all the preferences that… more»

Which other solutions did I evaluate?

I did not evaluate other options.
Martin Klier
Consultant
Senior Database Consultant at Performing Databases
Sep 30 2019

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… more»

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… 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… more»

What's my experience with pricing, setup cost, and licensing?

License is free, setup is simple and scriptable.

If you previously used a different solution, which one did you use and why did you switch?

I had to decide which solution we would use for a generic approach; and it was SQL Developer, in our case. At first, we worked with non-graphical utilities, command-line… more»

What other advice do I have?

I think you should make yourself familiar with this product and get into the core functionality first, before making a decision. I would rate it a nine out of 10 because I… more»

Which other solutions did I evaluate?

There are many capable vendors in this category, but since we usually work with Oracle, a product from Oracle was the first choice. In this case, it has the advantage that… more»
Find out what your peers are saying about Eclipse Luna vs. Oracle SQL Developer and other solutions. Updated: September 2019.
371,639 professionals have used our research since 2012.
Carlos Thomas
Real User
Senior Partner at a manufacturing company with 1-10 employees
Aug 22 2018

What is most valuable?

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.

How has it helped my organization?

If you make it the tool you use, everyone can talk the same "language" in terms of the tool and the use cases. Once you know it, how to use it, you can tell the whole organization how a given task… more»

What needs improvement?

There is room for improvement in the Real Time SQL Monitoring.

What's my experience with pricing, setup cost, and licensing?

It's free.

If you previously used a different solution, which one did you use and why did you switch?

Developer is centered on Oracle. I have the need now to monitor a much larger diversity of things. We are talking about monitoring cloud infrastructure where you have machines, where you have many… more»

What other advice do I have?

In terms of advice, I would first ask you what you are expecting from the tool and, if it is in the scope of Oracle SQL Developer, I would recommend it. I rate this solution at nine out of 10. It… more»
Iudith Mentzel
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… 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… more»

If you previously used a different solution, which one did you use and why did you switch?

Personally, I always prefer to use a product from Oracle. First of all, this one is free. And second, it is not so complicated. In another company, for example, the strategic development tool was Toad. And they have even joined Toad with a version manager, the specific version manager, and everybody… more»

What other advice do I have?

I think it's a good product in the sense that it does not overwhelm you with many features. So I would give it a 10 out of 10. I would recommend it.
Peter Silwinski
Consultant
Senior Consultant at Contracted by Siemens
Jun 06 2018

What is most valuable?

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.

How has it helped my organization?

* It is very easy to use. * I have a lot of flexibility with it. * For DBA tasks, it is also very good.

What needs improvement?

The competing products have more features.

What's my experience with pricing, setup cost, and licensing?

It is basically free.

What other advice do I have?

Try this if you do not need a lot of storage, especially since it is free and if it is the newer version with no GUI version. Everybody should try it because you do not have to code things to create output from JSON or DDL. It allows you to… more»
Real User
DBA at a tech services company with 51-200 employees
Jun 06 2018

What is most valuable?

The possibility to connect.

How has it helped my organization?

The main benefit of SQL Developer is that it is free.

What needs improvement?

There are many additional features I would like to see. The main one would be installation with an installer.

If you previously used a different solution, which one did you use and why did you switch?

We didn't have a previous solution but, in parallel, we use Toad; its license is expensive. The important criteria for me when selecting a vendor are good support and an affordable price.

What other advice do I have?

Using this solution depends on budget and on the number of developers. The more developers you have, the less you will want SQL Developer.
Real User
Sócio Diretor at a tech services company with 201-500 employees
Jan 16 2018

What is most valuable?

* Easy to use * Nice interface

How has it helped my organization?

Using execution plan, I am able to do lots of query tuning.

What needs improvement?

Execution plan.

What's my experience with pricing, setup cost, and licensing?

I have never paid for it, I use open source. In Brasil, only big companies can use Oracle because of the price. I prefer NoSQL and open source databases.

If you previously used a different solution, which one did you use and why did you switch?

I used Embarcadero and Toad. I gave up both because one is for every kind of database (I do not believe in this) and the other is only for Oracle, and its IDE is not good.

What other advice do I have?

Take care during the initial setup and have patience. It can be too heavy and eat your memory.

Which other solutions did I evaluate?

Embarcadero and Toad.
Daniel Grosovoi
Real User
DBA at Yediot
Jun 07 2018

What is most valuable?

It's free.

How has it helped my organization?

We have a QA team and we don't want to buy a special product for them just to query the database, so we use Oracle SQL Developer.

What needs improvement?

If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager.

If you previously used a different solution, which one did you use and why did you switch?

We used to use SQL *Plus, but we needed something with more of a GUI for users who are not technical users. When selecting a vendor the most important criterion is the price.

What other advice do I have?

Just try it. It's very easy.

Which other solutions did I evaluate?

This was the only free solution we evaluated. And it belongs to Oracle so that was good for us. Toad is much faster to use. It's not Java which takes a lot of time to query and create things. You just… more»
See 5 More Oracle SQL Developer Reviews

Articles

User Assessments By Topic About Oracle SQL Developer

Find out what your peers are saying about Eclipse Luna vs. Oracle SQL Developer and other solutions. Updated: September 2019.
371,639 professionals have used our research since 2012.

Oracle SQL Developer Questions

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

Read Archived Reviews
Sign Up with Email