Oracle SQL Developer Reviews & Insights

Score8.7 out of 10

491 Reviews and Ratings

Community insights

TrustRadius Insights for Oracle SQL Developer are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Seamless Integration: Users have consistently praised the seamless integration of Oracle SQL Developer with all versions of Oracle databases, eliminating the need for complex setup processes. This feature has been highlighted as a major advantage, enhancing user experience and workflow efficiency.

Easy Set-up and Installation: Reviewers appreciate the straightforward set-up and installation process of Oracle SQL Developer, along with its exceptional cross-OS compatibility. The ease of getting started with the tool has been positively acknowledged by users, making it accessible across different operating systems.

User-Friendly Interface: The simple user interface and effective functions contribute to the overall user-friendliness of Oracle SQL Developer, as expressed by users in their reviews. The intuitive design and smooth navigation enhance usability, allowing users to easily access and utilize various features within the application.

Oracle SQL Developer Reviews

3 Reviews

Small Businesses (1-50 employees)

Oracle SQL Developer does basic stuff right

Rating: 8 out of 10

Incentivized

January 2, 2018

Use Cases and Deployment Scope

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.

Pros

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.

Cons

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.

Likelihood to Recommend

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.

heather collins

senior developer in Engineering at ARM Marketing (Marketing and Advertising, 11-50 employees)

Vetted Review

5 years of experience

View profile

SQL Developer Review

Rating: 9 out of 10

Incentivized

November 30, 2017

Use Cases and Deployment Scope

I use SQL Developer (SD) for PL/SQL development. Being free from Oracle Corp, it is a very cost-effective way to build and maintain PL/SQL code. I like the main editor window that I can execute PL/SQL or SQL and get results. The SQL can be easily saved for future use in the form of a report. There is a nice history function that shows all of the code (last 100 things done I think...) SD executed. This feature is particularly handy when doing some SQL tuning with hints. Another nice feature is that SD supports the APEX environment, right out of the gate! You can easily view the APEX management data right from SD. SD also has code snippets and some code templates. The code snippets are drag and drop bits of code useful for various functions, SQL tuning (there is a category for all of the useful SQL hints), date functions, date/time masks, number/character conversions, and more. I have plugged my various useful SQL into the SD reports making them very easy to run.

Pros

PL/SQL Development: the tool's strength really. SD supports code condensing, parentheses/brace matching, insites (popup windows with data object column names, etc).
I like the report feature...very easy to add your library of SQL to be run as reports. SD works with bind variables in your SQL well too.
The history feature is particularly nice. It's called SQL Recall and it saves quite a number of PL/SQL and SQL code you have been working with for near-future reference and recovery if needed.
The code snippets is very nice. Various functions and function details at your fingertips. Use a drag and drop operation to add to your code.

Cons

SQL Tuning. SD has explained plans but these could easily be improved upon using the latest features of the Oracle RDBMS.
More code templates. You can add your own but the tool seems to be lacking a bit when it comes to pre-existing code examples.
Smaller foot print. The thing is huge and somewhat slow.
Seems every time I get a newer SD, I also have to upgrade the Java environment as well. Would be nice if they picked a rev of Java and stuck to it.

Likelihood to Recommend

SD is well suited for PL/SQL development, some data analysis, and executing of SQL. The price is certainly right at 'free'... I find it not as helpful when it comes to SQL performance tuning. I usually have to resort to SQL*Plus or other tools to run the more advanced performance tuning things such as SQL Trace.

Dan Hotka

author in Professional Services at McGraw-Hill (Computer Software, 1-10 employees)

Vetted Review

10 years of experience

View profile

Manages the giant with another giant

Rating: 9 out of 10

Incentivized

November 1, 2017

Use Cases and Deployment Scope

As a software developer, it is important to manage databases from a fast and reliable presentation. SQL Developer allow developers to quickly manage data on a par with project and development times. Not only that, but also gives you modeling and reporting tools that facilitate the documentation in the analysis and design phases.

Pros

Data modeling and reporting tools.
Create new databases for startups.
Simple data management, even in a complex environment like Oracle Database.

Cons

It works mainly for Oracle and does not work as easily with other databases like SQL Server.
Installation can be a problem if you are not used to Oracle installation process.

Likelihood to Recommend

If you are working with Oracle Database, SQL Developer is the way to go. If you go with other databases like SQL Server you could prefer SQL Management or Toad.

Miguel Angel Merino Vega

Analista de Sistemas in Information Technology at Consultor independiente de software (Computer Software, 1-10 employees)

Vetted Review

6 years of experience

View profile