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

7 Reviews

Engineering

Oracle SQL Developer the Masterclass for Database Work

Rating: 8 out of 10

Incentivized

June 4, 2021

Use Cases and Deployment Scope

Oracle SQL Developer is used to solve production issues for our client. It is used across the whole organization by different support and development teams. The business problems that it solves is production issue that occur when the business runs. Using Oracle SQL Developer we ensure that our business runs smoothly.

Pros

The various contents of a database can be viewed using the connection tree
We can run SQL queries to generate reports in various formats
Debugging of queries is smooth

Cons

More RAM usage by SQL Developer which makes it slow sometimes for big queries
The database automatically gets disconnected when it is idle for sometime
Auto-completion of queries is not available

Likelihood to Recommend

SQL Developer is well suited for solving production issues by doing data fixes. SQL Developer is well suited for extracting reports from database. It is well suited for debugging queries. It is well suited for designing and developing new database.PL/SQL development can easily be done through it. It is best suited for doing DML and DDl updates of database.

Ankur Karmakar

Programmer Analyst Trainee in Engineering at Cognizant (Computer Software, 10,001+ employees)

Vetted Review

1 year of experience

View profile

Reliable tool for Oracle DBs

Rating: 10 out of 10

Incentivized

December 12, 2019

Use Cases and Deployment Scope

SQL developer is still being used as one of the main tools for manipulating our databases. Although for development, the built-in tools suffice, this professional tool is still used widely by our DBAs. A reliable, and well-supported tool, which is excellent to utilize the power of PL/SQL and Oracle databases.

Pros

Database manipulation and SQL editing.
PL/SQL code development.

Cons

Modern IDE like features, like wider linting support.
More customization.

Likelihood to Recommend

This is a free, very easy to use tool, and also quite widely used. If somebody wants to learn SQL and PL/SQL, this is the number one tool to begin with. Also, for Oracle databases, this tool works quite well and has some integrated solutions that other SQL IDE's lack. This functions well as a platform for new users and for highly trained professionals as well.

Alternatives

IntelliJ IDEA

IDEA has a built-in database connection and query platform. It has a slightly better code completion feature but lacks many of the functions of the SQL developer.

Balázs Kiss

Software Developer in Engineering at Webvalto Ltd. (Banking, 51-200 employees)

Vetted Review

8 years of experience

View profile

Oracle SQL Developer is an easy to use tool, but not good at multi-tasking

Rating: 5 out of 10

Incentivized

September 19, 2019

Use Cases and Deployment Scope

This product is being used across our entire company. It allows us to interact with our databases to review and correct data.

Pros

Easy to use.
Beginner and power user-friendly.

Cons

I wish that you could view multiple tables in the same database at the same time.
I wish that you could easily open multiple databases at the same time in the same instance.
I often misclick when opening a database, so it would be nice to either launch it faster or not immediately open (or at least have the option to enable a soft validation).

Likelihood to Recommend

It works well for visually examining/altering a database. It fails at multitasking in databases.

Verified User

Analyst in Engineering (Utilities company, 201-500 employees)

Vetted Review

2 years of experience

Great software that help us save time an resources with Queries and Database stuff

Rating: 9 out of 10

Incentivized

December 7, 2018

Use Cases and Deployment Scope

We as a group of developers use SQL developer to integrate the queries for our apps and to better understand our database designs.

Pros

One of the things that SQL Developer is really good at is helping us view and export database structures to see if it needs some design optimization. Sometimes, as a developer I need to check that out.
SQL Developer also offers stability in the management of query executions.
And, one of the main advatages of SQL Developer over other options is the easy way that let you have multiple connections open, and change between them.

Cons

I think SQL Developer needs to improve its funcionallity to export data in multiple formats from queries. It will help us generate reports.
I do not see SQL Developer as the best tool to perform data migratios, perhaps that is an opportunity of improvement.

Likelihood to Recommend

SQL Developer is a recommended software in cases like getting track of database objects and designing queries during the process of software development in any platform. For example, we use it when we implement a new Java app and need to be sure that objects and business logic are in line with our database structure.

I think it's a great tool for me as a software developer. However, as a DBA I think it would not be the only software I depend on to perform some data processes, although it can be really useful too.

Alternatives

Oracle Database

I think Oracle Database and SQL Developer work well together and they do not necessarily have to stack up against each other.

Victor Toscano

Desarrollador de software in Engineering at Universidad de Guadalajara (Education Management, 10,001+ employees)

Vetted Review

5 years of experience

View profile

SQL Developer

Rating: 9 out of 10

Incentivized

October 24, 2018

Use Cases and Deployment Scope

We use SQL Developer to process various database items into a large scalable database that is used for our ground system.

Pros

SQL Developer is nicely integrated and provides greater visibility into schemas as well as data.
SQL Developer allows easy access to fields view and data view of multiple schemas
Allows repository type of view that enables ease of browsing thru tables without extensive use of SQL.

Cons

SQL Developer is already intuitive, but could be more user friendly by utilizing a UI based design.
SQL Developer could use more of an IDE-type look and feel.
Addition of more Database admin type functionalities.

Likelihood to Recommend

SQL Developer is well suited for any level of database experience.

Alternatives

I do not have any usage of other products besides using either command line SQL or SQL Developer.

Nikhil Patel

Software Engineering Manager & Architect in Engineering at Lockheed Martin Space Systems Company (Defense & Space, 10,001+ employees)

Vetted Review

10 years of experience

View profile

Quality application with room for improvement

Rating: 9 out of 10

Incentivized

October 24, 2018

Use Cases and Deployment Scope

It is used across the IT area within the company for db management. My team allows our developers to use this tool to provide technical support for our production applications when issues arise. They can review the data in the system to determine if the issue was in the data or the codebase. It is also used in our testing environments to allow our developers create and update testing data.

Pros

It connects with Oracle dbs with ease.
The query optimization tools are readily available and easy to use.

Cons

Occasionally the application will freeze when it fails to properly connect to a database.
It tends to be a very resources heavy and can freeze when running longer queries, with no way to stop the execution.
There is no clean way to change the user's password within the UI.

Likelihood to Recommend

Well suited for any management of Oracle DBs.

Alternatives

Toad for Oracle

It was less expensive to provide than Toad, and more useful than SQL Plus.

Verified User

Engineer in Engineering (Transportation/Trucking/Railroad company, 10,001+ employees)

Vetted Review

8 years of experience

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.

Alternatives

Mysql workbench and Apache Derby

heather collins

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

Vetted Review

5 years of experience

View profile

Loading Reviews List....