Oracle SQL developer, a swiss army knife for DBAs
Updated October 25, 2017

Oracle SQL developer, a swiss army knife for DBAs

Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQL Developer

We use SQL developer in our dev shop to access our database tables. It is the default product being used by the DBAs across our organization as well. Its a handy tool, that's freely available and can access non-Oracle databases as well.
  • It can be downloaded and used for free from the internet.
  • It is very useful in formatting SQL queries into Java code and vice versa.
  • It can be used for DML operations like, inserting, updating and deleting data as well.
  • It is a very resource intensive application and hogs the RAM and CPU cycles quite a bit.
  • It does not offer very easy integration with non-Oracle databases like IBM DB2 or SQL Server.
  • It has really helped the application developers access the underlying databases through a simple tool.
  • It assists non technical people to easily view data in the database tables.
Prior to SQL developer, I was using the Apache Database connection add on for Eclipse IDE. It was also convenient to view the databases right from within Eclipse, however, the functionality was really limited.
Its ideal for basic database operations like viewing some records, checking the SQL DDL for the tables defined. Also you can perform CRUD operations by just point and click technique.