Oracle SQL Developer Reviews

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.

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.

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, where you can't do that in PL/SQL Developer, the layout is what I would suggest as far as an area with room for improvement.

SQL Developer is very stable; never had an issue.

I only work on a Lenovo Windows machine. I don't work on Apples. I don't know if it's scalable there or not.

I have used technical support for this solution and they get back within 24 hours with a user-friendly answer. It's very good.

The company actually was using Toad, by Quest, and it's very expensive. It's user friendly but a developer shouldn’t need a super user-friendly solution. Also, SQL Developer's free; it comes with the install, the Oracle client.

When I’m selecting a vendor such as Oracle, the most important criteria is look for is reliability.

I installed it: downloaded, installed, configured; very easy.

I chose this product because it has a solution for all our needs, such as reporting, the PI, the development, the jobs themselves run on/out of the Oracle database. It was the total solution.

Read as much as you can. Just use it. I've been doing this for 25 years, so it's very easy to me. The more you do it, the easier it is.

It's just the best out there.

I am using Oracle SQL Developer for formulas to find results in the databases.

The most valuable features of Oracle SQL Developer that I use. However, I do not use all of them

Oracle SQL Developer could improve the speed, it is a bit slow.

I have used Oracle SQL Developer for approximately six months.

The stability of Oracle SQL Developer is okay.

Oracle SQL Developer is scalable. It can perform the same when more people use it.

Most of the people in my organization are using Oracle SQL Developer. We have approximately 100 people in the organization.

I have not used the support from Oracle SQL Developer.

The initial setup of Oracle SQL Developer is straightforward.

For first-time users of Oracle SQL Developer, it's going to be a bit difficult, but they can find their way around over time.

I rate Oracle SQL Developer a nine out of ten.

I didn't face any other issues other than it being a bit slow when you have a lot of work to do.

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 always been a challenging and time consuming task. Data modeling always helped me with several projects by being able to draw objects in the plane in no time.

Another interesting feature of SQL Developer is Data Pump. It makes exporting and importing data easier. The wizard form for Data Pump relieves the developer from writing a whole chunk of code, which is a huge relief.

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 memory space, which makes it more efficient and faster. Furthermore, it has an easy installation process that leads to the company spending less time and money on lengthy trainings for its employees; just a refresher course is enough! This single software can connect with other databases provided by different vendors such as Microsoft SQL Server and MySQL, etc.

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.

I have been using SQL Developer for the last three years on a daily basis.

Till now, I haven’t faced any stability issues while working with SQL Developer.

To be frank, I haven’t had the chance to evaluate this software with respect to its scalability.

I didn’t get a chance to talk with technical support because whenever I faced any problem, I just tweeted about it and got the solution from the community. So, a great many thanks to them for helping me out!

I often switch between SQL Developer and TOAD for Oracle depending on their suitability regarding the project that I am working on.

The initial setup was very simple. I just had to download and extract the files. That’s all!

It is an open-source software available for free from Oracle Corporation so no issues with pricing and licensing.

I evaluated TOAD for Oracle, but after using SQL Developer, I kind of grew a liking towards the latter.

It is a great open-source software, power packed with features. The initial setup is simple, which means less mess in terms of training the employees. Moreover, it is fairly stable which makes it a wonderful choice.

Export option on query results.

Faster access to DB tables.

Could be made to load faster.

Five years.

No.

No.

No.

Good.

Good.

Yes.

It was easy.

Good.

Good.

No changes required.

No.

Off the top of my head (I don't use it that often):

• Included Oracle SQL Developer 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

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 getting better with every release. I would have rated it much lower a couple of years ago. With Oracle's resources, it could be much much better.

I have used this solution for eight years.

It is not very stable on MacOS, but it's much better on Windows I think.

I haven't used customer service.

I haven't used technical support.

IDE help is there, but it could be much better.

I did and still haven't fully switched to Oracle SQL Developer.

Setup is piece of cake. Various options are well hidden in settings, but the search helps a lot.

An in-house team implemented it.

It's free. The required time investment and change of thinking while using it is too much for me, anytime I seriously think about switching to Oracle SQL Developer as my main tool for PL/SQL development.

Invest enough time beforehand so you would fully understand how Oracle SQL Developer works and behaves in some situations. It is a very powerful tool, but sometimes it "works in mysterious ways", just like any Oracle's desktop product. (JDeveloper is the best example.)

The primary use case is developing and maintaining databases.

Maintaining databases is the most valuable feature in Oracle SQL Developer. It's also easy to use, fast, and intuitive.

I would like to see better tuning modules. It could also be more intuitive, easier to use, not so complicated finding the things you need to do, and support background processes better.

It's not so stable. Sometimes it crashes, and the connection to the databases is bad. 

The scalability is very good. It can scale out, up.

When selecting a vendor the most important criterion is that they are professional.

I rate this solution at six out of 10 because there are better tools that I am using. One of them is Toad, from Quest Software. Toad is more intuitive, easier to use, doing better work, and has more features.

I prefer Toad. But if it is a question of budget, it's better to use SQL Developer.

Database querying, curating scripts, and database tuning.

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.

It's free.

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

It's stable. It's a little bit slower because of Java, but it's stable.

It's scalable.

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.

Setup is very easy.

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 install it on Windows and it works perfectly. Much better than the Java.

Just try it. It's very easy.

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

• Easy to use
• Nice interface

Execution plan.

Because it is in Java, sometimes Java crashes the product, and of course there is the total dependence on Java.

I have never stressed the product to find out.

I have never needed to contact technical support.

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.

The initial setup is always a problem, it cannot find the Java SDK.

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.

 Embarcadero and Toad.

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