A nice client tool
November 26, 2018

A nice client tool

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

Overall Satisfaction with Oracle SQL Developer

SQL Developers is used by many developers and DBA across several departments in our company.

Pros

  • Comparing with native SQLPLUS, or command line interface, SQL Developer provides a user-friendly interface to communicate with Oracle databases.
  • As a DBA, I especially like the DBA tools which can manipulate AWR, configure Resource Manager, launch SQL Tuning Advisor, etc.
  • Another function people use a lot is to export a table into csv format. SQL Developer makes it very easy.

Cons

  • SQL Developer doesn't support MySQL database. We need to use MySQL Workbench. It would great if a single client tool woks for all DBs someday.
  • The explain plan can be shown as a better diagram. For a long sophisticated plan, it is not very easy to read and to catch where the bottleneck is
  • I don't find partition display in SQL Developers
  • Since this is a free tool, it definitely gives a positive impact.
  • Many developers and DBAs use it as a daily tool.
  • It is easy to set up, intuitive to use. Needs minimum support.
SQL Developer is free, and it is providing more and more functions.
Many developers who are not familiar with dictionary views find SQL Developer a nice GUI to access DB objects. In addition to DBConsole and command lines, DBAs now have one more interface to manage jobs, reports, configurations. SQL Developer is free, which is a great benefit comparing with some other client tools. I use command line most of the time, which I am used to, and it gives nice display of execution plans.

Comments

More Reviews of SQL Developer

  1. Home
  2. Integrated Development Environment (IDE) Software
  3. SQL Developer Reviews
  4. User Review of SQL Developer