Oracle SQL Developer Review

I can see all of the database objects within each schema, edit them and create new ones.


What is most valuable?

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.

How has it helped my organization?

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.

What needs improvement?

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.

What do I think about the stability of the solution?

SQL Developer is very stable; never had an issue.

What do I think about the scalability of the solution?

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.

How are customer service and technical support?

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

Which solution did I use previously and why did I switch?

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.

How was the initial setup?

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

Which other solutions did I evaluate?

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.

What other advice do I have?

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.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Oracle SQL Developer reviews from users
Add a Comment
ITCS user
Guest