Oracle SQL Developer does basic stuff right
January 02, 2018

Oracle SQL Developer does basic stuff right

heather collins | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle SQL Developer

Oracle SQL Developer is a very robust tool that we use in our company for accessing our databases. It can be downloaded for free and is capable of interfacing with non-Oracle databases like MySQL, SQL Server as well. It is a very simple tool and offers good value to both DBAs and developers alike.
  • With an intuitive user interface, Oracle SQL developer is great for point and click DML operations like inserts, updates, and deletes.
  • It's available for free from Oracle's website and gets frequent updates as well.
  • I found that integration with non-Oracle databases like UDB can sometimes be tricky with downloading third-party database drivers.
  • Some versions of this application have been slightly unstable and have frequently needed updates to the Java JDK installations.
  • For developers who are not trained as seasoned DBAs, Oracle SQL Developer is an ideal tool for accessing underlying database tables.
  • With the right permissions and access control, you can even create database triggers and Stored Procedures.
Oracle SQL Developer is ideal for everyday common database CRUD operations. It is also helpful in formatting SQL queries into Java code and vice versa.