Oracle SQL Developer Professional, Scientific, and Technical Services 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.

Reviews

12 Reviews

Professional, Scientific, and Technical Services

Oracle SQL Developer Review

Rating: 9 out of 10

Incentivized

December 11, 2024

Use Cases and Deployment Scope

We are using Oracle in integration with TIBCO AMX BPM to store data for managing users, update KYC details, store daily operations data etc. Oracle SQL Developer provides a solid graphical user interface to view and update data. It is easy to segregate data using schema names in Oracle SQL Developer. Both developers and administrators are using Oracle SQL Developer as it is easy to learn and use. We have created tables, views, stored procedures and indexes using Oracle SQL Developer.

Pros

Easy to create stored procedure
Easy data management using GUI
IntelliSense for guiding query building
Support for multiple schemas within single connection

Cons

Might not be suitable for Production environment
Scaling is limited
Can be difficult to operate for beginners

Likelihood to Recommend

Oracle SQL Developer helps obtain performance metrics by showing the time taken to run any query or stored procedure. It allows to create indexes on tables for fetching results much faster. We can create sequence which can be configured for auto increase and is useful for numbering the records stored in the tables. Before connecting to any server there is an option to test the credentials which allows verification of credentials without blocking the connection when user is not too sure about the password. It provides support for queues, XML schemas as well

Verified User

Employee in Information Technology (Accounting company, 5001-10,000 employees)

Vetted Review

9 years of experience

One of the fine IDE tool - Oracle SQL Developer

Rating: 8 out of 10

Incentivized

May 19, 2021

Use Cases and Deployment Scope

In the part of the data migration and integration process, we are analyzing end-points in front-end and in back-end also. For backend data analysis and extract purposes, we use the Oracle SQL developer tool for DB connectivity. It works fine with Oracle and also relational databases. We mostly work on SQL developer editors for SQL, PL/SQL query testing, executions, and data extracting from instances.

Pros

The efficient connectivity with various Oracle and relational databases.
The options for fastest query building and execution. The debugging options also displays exact error message of the query, if any bug in query.
We can export extracted data in various file formats.
Simple user interface and effective functions for user friendliness.

Cons

When the connected database is disconnected due to some issues, the re-connection option does not work properly all the time.
For the long time executions, tool gets unstable state.
The report and documentation features need to updated.

Likelihood to Recommend

The Oracle SQL Developer tool performing well in most of the data analyzing process stages except one or two processes. We can develop and analyze SQL queries by connecting multiple databases in a single frame. In the complex or huge line query executions, we cannot find the exact execution status. It needs to be added for better understanding in the execution stage.

Verified User

Consultant in Information Technology (Information Technology & Services company, 1001-5000 employees)

Vetted Review

3 years of experience

Free, simple to use and complete development IDE for Oracle databases

Rating: 9 out of 10

Incentivized

May 13, 2021

Use Cases and Deployment Scope

[Oracle] SQL Developer is a free to use IDE that allows to manage and use Oracle databases both on premise and in the cloud. We used it in the different development teams to design and develop Oracle databases, allowing to easily create tables, views, procedures and functions. We also used some of the features to troubleshoot or monitor small incidents (like performance bottleneck) in our development and testing environments.

Pros

Ability to browse across all database components and easily modify or drop them, or create new ones.
Very simple to use and learn, yet includes many personalization options (like snippets and SQL history)
You can define window border colors for different connections, thus easily identifying production or sensitive environments at glance!
Import and Export data in a very simple way

Cons

Being a JAVA application, response times are sometimes not as good as native applications
Sometimes it uses more RAM than expected
Sometimes gets disconnected from DB

Likelihood to Recommend

Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.

It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.

Lisandro Fernigrini

Database Practice Lead in Information Technology at Kapsch Trafficcom Argentina S.A. (Information Technology and Services, 201-500 employees)

Vetted Review

8 years of experience

View profile

Oracle SQL Developer: my daily work buddy

Rating: 10 out of 10

Incentivized

October 31, 2019

Use Cases and Deployment Scope

Oracle SQL Developer is a popular tool we use here at our organization. Developers, DBAs and data architects all use this tool. We use it for running queries, DBA administration, and Data Modeling. In the DBA section, it provides database configuration - initialization parameters, current database properties, and database stats—the instance viewer is super nice.

Pros

DBA section: automatic undo management, initialization parameters, database feature usage, instance viewer (CPU, session, top SQL, processes,etc.).
Memory/storage: beautiful graphics, performance, backup/recovery, security (roles, users, profiles, and auditing). All is nicely displayed!
SQL Worksheet: I can run queries in a database, hop to a different database, run the same query or different one. All can be done in one console.
I have connections set up for 40 databases, switch between databases - very convenient. Queries can be kept in History or save to a notepad.
Tools: 1.Modeling is a nice addition in SQL Developer. I don't use it for creating logical models. However, I find it very helpful to look at the model and understand the relationship between tables and schemas.
Database copy: make a copy of the database from source to destination with many different options - object copy, tablespace copy, schema copy, copy DDL, copy data.
Database diff: make comparisons between databases
Database export with many options based on requirements.
SQL Worksheet: listed above
Session monitoring: who is logged in.
Real-time SQL monitoring: insight into how to tune a poorly written query. It does, however, need an additional license.
General: tables are nicely displayed. I used it every day. I can see column, data model, constraints, grants, statistics, triggers, dependencies, partitions, indexes and I can generate SQL DDL!

Cons

A dashboard to display database status: all database connected/registered, general info, database up/down, version, size and which server it's on.
Schedule jobs to be run.

Likelihood to Recommend

In general, it's well suited for developers, DBAs and data architects to run queries, display databases, database object info, DBA activities, and modeling. However, I am not sure it is best suited for generating DDL to automate the ETL process for example. Overall, this is my go-to tool for daily database activities.

Verified User

Consultant in Research & Development (Research company, 10,001+ employees)

Vetted Review

15 years of experience

Oracle SQL Developer - Solid for Oracle Database Implementations.

Rating: 9 out of 10

Incentivized

September 18, 2019

Use Cases and Deployment Scope

Oracle SQL Developer is being used by our development team to provide introspection to the performance of our production baseline. Additionally, it's used during development to pilot capabilities, integrations and for rapid proof of concept implementation.

Pros

Seamless database management integration
Process stack analysis
Modeling and visualizations

Cons

Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas.
Detailed analysis of models can be clunky for complex relational models.

Likelihood to Recommend

You can utilize Oracle SQL Developer for package analysis, prototyping, troubleshooting for all phases of the SDLC.

Verified User

Manager in Information Technology (Information Technology and Services company, 501-1000 employees)

Vetted Review

10 years of experience

No nonsense IDE. Why complicate your life.

Rating: 9 out of 10

Incentivized

September 18, 2019

Use Cases and Deployment Scope

Oracle developer is our main development tool for PL/SQL and database management. It is being used by our department and across the company. It simplifies the development and management of our various databases and data warehouses.

Pros

Presentation of objects contained in the database
Autocomplete of SQL code
Running multiple statements at the same time

Cons

Importing and exporting data to the cloud from on-prem
Code versioning
Prettier and smoother UI graphics

Likelihood to Recommend

It's well suited for all things database related.

Verified User

Director (Marketing and Advertising company, 201-500 employees)

Vetted Review

10 years of experience

Looking for a better way to Develop SQL

Rating: 8 out of 10

Incentivized

September 18, 2019

Use Cases and Deployment Scope

To develop SQL Code and design database objects along with data migration across the whole organization. It allows us to import and export data to other data platforms. And we can generate quick DDL and review the tables/views and contents effectively. Since we are new to the tool and trying to migrate our data to the cloud, it would be helpful if the data export feature to the cloud could be improved.

Pros

It lets us create new objects easily and modify the DDL within the tool quite easily.
I love the data review tab that shows the data quickly and helps us profile the data.
Exporting data from one object to another is great.

Cons

Import/export data to the cloud.
Does not do a good job of auto-connecting to a previous connection and you have to go through a couple of clicks and refresh.

Likelihood to Recommend

It is well suited to develop new SQL code and create new objects.

Verified User

Engineer in Information Technology (Marketing and Advertising company, 201-500 employees)

Vetted Review

1 year of experience

SQL Developer, best Oracle tool for a developer

Rating: 7 out of 10

Incentivized

October 29, 2018

Use Cases and Deployment Scope

My department and organization uses Oracle SQL Developer to use and manage Oracle Database 12c a better way. My team uses Oracle SQL developer, as it is a graphical tool which honestly makes it quite easier to not only use and manage Oracle Databases, but also train new junior DBAs to do the same. It's easy to learn and understand.

Pros

It's free
Very useful to organize different Oracle Databases or connections
Easy to use, user friendly, and quite intuitive

Cons

Not useful if you are not using Oracle Database
Quite slow even when using Oracle Database, many other faster products like this out there
No export feature, like a CSV or Excel format

Likelihood to Recommend

Oracle SQL Developer is best suited while using Oracle Databases, may it be any versions or any Oracle Databases. But if you try using it with any other databases such as MariaDB or MySQL, it does not work very well, in fact it is quite useless. But I have to say, it is quite easy to use, and install.

Verified User

Engineer in Information Technology (Information Technology and Services company, 10,001+ employees)

Vetted Review

The only SQL development tool most people need.

Rating: 9 out of 10

Incentivized

May 29, 2018

Use Cases and Deployment Scope

SQL Developer is being used by the data management team at my current climate to do data analysis and data preparation. It is the starting point for most reports and also where we merge data from multiple data sources. Very few business people have any knowledge of SQL and so they need the team to use SQL developer for bother recurring and ad hoc queries.

Pros

Performs well even with large amounts of data
Helps finds SQL errors before runtime
Easy to install and upgrade.

Cons

Embedded documentation for PL/SQL functions is lacking
Integrations with other data sources
Not useful if you don't have strong SQL skills

Likelihood to Recommend

If you have an Oracle Data warehouse, then you do not actually need a different IDE for your data development. In the past, it was necessary to have TOAD or something similar, but now the new versions of SQL developer allow it to be used for most use cases. Very stable and great for analysts and DBAs.

George Robbins

Integration/Analytics Consultant in Information Technology at Concord (Information Technology and Services, 201-500 employees)

Vetted Review

5 years of experience

View profile

Why Should i Trust SQL?

Rating: 10 out of 10

Incentivized

January 31, 2018

Use Cases and Deployment Scope

SQL Dev is being used in different projects since I'm working for a Consultant Company, it's totally related to the project requirements. It's so helpful to manage and query all the DWH instances and the database themselves.

Pros

Great Activity Monitoring
Great Management of Databases and Objects on the instance
Great Query Optimization module

Cons

Machine Learning Functionalities
Auto-format of the code
Resource Management

Likelihood to Recommend

Well suited for management of dwh both in small than in big sizes. Not really suitable for Big Data Management.

Luigi Vecchione

Business Analyst Specialist in Information Technology at ICONSULTING (Information Technology and Services, 51-200 employees)

Vetted Review

2 years of experience

View profile

Loading Reviews List....

Oracle SQL Developer: my daily work buddy

Rating: 10 out of 10

Incentivized

October 31, 2019

Use Cases and Deployment Scope

Pros

DBA section: automatic undo management, initialization parameters, database feature usage, instance viewer (CPU, session, top SQL, processes,etc.).
Memory/storage: beautiful graphics, performance, backup/recovery, security (roles, users, profiles, and auditing). All is nicely displayed!
SQL Worksheet: I can run queries in a database, hop to a different database, run the same query or different one. All can be done in one console.
I have connections set up for 40 databases, switch between databases - very convenient. Queries can be kept in History or save to a notepad.
Tools: 1.Modeling is a nice addition in SQL Developer. I don't use it for creating logical models. However, I find it very helpful to look at the model and understand the relationship between tables and schemas.
Database copy: make a copy of the database from source to destination with many different options - object copy, tablespace copy, schema copy, copy DDL, copy data.
Database diff: make comparisons between databases
Database export with many options based on requirements.
SQL Worksheet: listed above
Session monitoring: who is logged in.
Real-time SQL monitoring: insight into how to tune a poorly written query. It does, however, need an additional license.
General: tables are nicely displayed. I used it every day. I can see column, data model, constraints, grants, statistics, triggers, dependencies, partitions, indexes and I can generate SQL DDL!

Cons

A dashboard to display database status: all database connected/registered, general info, database up/down, version, size and which server it's on.
Schedule jobs to be run.

Likelihood to Recommend

Verified User

Consultant in Research & Development (Research company, 10,001+ employees)

Vetted Review

15 years of experience