Oracle SQL Developer, a productive tool for Oracle developer
April 30, 2021

Oracle SQL Developer, a productive tool for Oracle developer

Joe He | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle SQL Developer

In our company, Oracle SQL Developer is using by Oracle developer by default in AppDev department across the global. We use Oracle SQL Developer since Oracle 11g, replaced the license product Toad for Oracle. Oracle SQL Developer able to provide all the feature required by database development activities.
  • Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
  • The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
  • DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
  • Showing more detail on real-time database performance data
  • Integration with AWR report
  • Show more diagnostic info on Oracle RAC
  • It's a free product with all the feature developer need to do their job
  • Huge saving compare to other licensed product
  • Increase the productive on application development
Oracle SQL Developer is available on multiple platforms, Windows Mac Linux and it's free. SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage and develop Oracle Database in both on premise and Cloud deployments. SQL Developer can also connect and interact with non oracle database like MS SQL server and MySQL etc.

Do you think Oracle SQL Developer delivers good value for the price?

Yes

Are you happy with Oracle SQL Developer's feature set?

Yes

Did Oracle SQL Developer live up to sales and marketing promises?

Yes

Did implementation of Oracle SQL Developer go as expected?

Yes

Would you buy Oracle SQL Developer again?

Yes

The Procedure Editor is a complete IDE for the PL/SQL programming language. Stored Procedures, Functions, Packages, Types, and Triggers can be executed, compiled, refactored and more using the Procedure Editor. Access the Procedure Editor by clicking on a PL/SQL object in the connection tree or by opening a file with a file extension mapped to PL/SQL objects.