Oracle SQL Developer Review

Other PL/SQL IDE don't have the same modelling capabilities.


Valuable Features

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

Room for Improvement

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.

Use of Solution

I have used this solution for eight years.

Stability Issues

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

Customer Service and Technical Support

Customer Service:

I haven't used customer service.

Technical Support:

I haven't used technical support.

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

Previous Solutions

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

Initial Setup

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

Implementation Team

An in-house team implemented it.

ROI

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.

Other Advice

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.)

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is an Oracle Gold Partner.
1 visitor found this review helpful
2 Comments
Kent GrazianoVendor

Best way to figure out the "mysterious ways" of SQL Developer is to ask questions on the OTN discussion forum for SQL Dev (it is also free) and follow product manager Jeff Smith on twitter and his blog (thatjeffsmith.com) where he writes a ton about the features and functions of SQL Developer and SQL Dev Data Modeler

04 January 17
Assistant Director, Applications Development Services in the Student Collaboration Center at Temple UniversityReal UserTOP 20LEADERBOARD

I only recently started using the data modeler, and it's most useful to me, for figuring out parent-child table relationships in our ERP system's database (ellucian's Banner). I use SQL Developer every day on the job. I haven't found a better tool!

04 January 17
Guest
Sign Up with Email