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

50 Reviews

Enterprises (1,001+ employees)

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

Easy data surfing

Rating: 8 out of 10

Incentivized

December 21, 2023

Use Cases and Deployment Scope

I use Oracle SQL Developer as an editor to run various queries and export data to my desired format as Excel or CSV files. I usually use it on Windows, but it could be used on other operating systems, so it is a great advantage for me when I change platforms.

Pros

Export Data
Run SQL statements
Browse Database Objects

Cons

Search for a specific object in the database
Debug

Likelihood to Recommend

Scenario where Oracle SQL Developer is well suited could be to browse, create, edit and drop database objects; execute SQL statements and scripts; edit and debug PL/SQL code; manipulate and export data; and view and create reports. I never encounter some situations for what I need where Oracle SQL Developer is not.

Paolo Carzaniga

Senior Application Engineer in Information Technology at STMicroelectronics (Semiconductors, 10,001+ employees)

Vetted Review

5 years of experience

View profile

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

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

Oracle SQL Developer True Review

Rating: 8 out of 10

Incentivized

May 14, 2021

Use Cases and Deployment Scope

I create web and desktop applications which use SQL developer as back end and stores all the data in it. It is used by whole department and all the users to read and write. It used to maintain historic data and generate monthly reports. It's also help us to generate multiple queries and format the data when needed

Pros

Better Performance
Good User interface
Advance Options
Big Data

Cons

Syntax
Intellisense
Type casting

Likelihood to Recommend

There are many scenarios where Oracle SQL Developer is suited. Where we need historic data and huge amount of data is need and searched every minute this help us for fast response from data base. When organizations need strict business and regulatory requirements. Oracle works best with Linux environments and gives best performance results.

Rohit Goyal

Risk Analyst in Information Technology at Deutsche Bank (Banking, 10,001+ employees)

Vetted Review

6 years of experience

View profile

Oracle SQL Developer, a productive tool for Oracle developer

Rating: 9 out of 10

Incentivized

April 30, 2021

Use Cases and Deployment Scope

In our company, Oracle SQL Developer is using by Oracle developer by default in AppDev department across the global. We use Oracle SQL Developer since Oracle 11g, replaced the license product Toad for Oracle. Oracle SQL Developer able to provide all the feature required by database development activities.

Pros

Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.

Cons

Showing more detail on real-time database performance data
Integration with AWR report
Show more diagnostic info on Oracle RAC

Likelihood to Recommend

The Procedure Editor is a complete IDE for the PL/SQL programming language. Stored Procedures, Functions, Packages, Types, and Triggers can be executed, compiled, refactored and more using the Procedure Editor. Access the Procedure Editor by clicking on a PL/SQL object in the connection tree or by opening a file with a file extension mapped to PL/SQL objects.

Joe He

Lead Database Administrator in Information Technology at Concentrix Corporation (Outsourcing/Offshoring, 10,001+ employees)

Vetted Review

10 years of experience

View profile

Intuitive and powerful, provides tools and utilities users to handle advanced user requirements

Rating: 9 out of 10

Incentivized

April 15, 2021

Use Cases and Deployment Scope

My organization is using Oracle SQL Developer as the main interface utility for a large patient related database. Oracle SQL Developer functions as a report writing tool, maintenance, upgrade validation, and testing utility.

Pros

Easy interface with large selection of useful utilities.
Import and export of pre-configured SQL connections for easy duplication.
Snippets, history, and other utilities add quick custom functionality.

Cons

Some database design tools found in other SQL tools are not yet available.
Customizing utility windows does not save after restarting application.

Likelihood to Recommend

The Oracle SQL Developer utility is excellent for common scenarios requiring access to Oracle for report writing, maintenance, and validation tasks. For advanced scheduling of procedures or other event related processes, various other tools provide additional functionality.

Lee Luchs

Senior Solutions Analytics Consultant in Information Technology at Kaiser Permanente (Hospital & Health Care, 10,001+ employees)

Vetted Review

5 years of experience

View profile

Software for everyone using DB

Rating: 8 out of 10

Incentivized

April 13, 2021

Use Cases and Deployment Scope

Oracle SQL Developer is used by each and every department in my organization but not all employees work on it. Mainly it is used to store data my organization works on. It is used to keep records of my company for a long time without any need to delete--also hassle free maintenance of data.

Pros

Simple UI. Even new joiners can easily use it.
Autocomplete feature. It recommends a completion for every line.
Debugging is easy. Oracle SQL Developer displays what ever the error is.
Supports various kind of DB. Not just SQL.
Easy installation and setup.
It is free to use and one doesn't need to buy anything.
Easily export data into different formats like Excel, TSV file, text file, html, etc.

Cons

There are fewer features compared to other software available in market.
Good quality reporting, sorting ,filtering features are not available.
Lags upon heavy usage.
Connection from DB gets disconnected if query is stopped.
Query running status still comes even if at the backend the query has been stopped and person keeps on waiting.

Likelihood to Recommend

It is well suited when one doesn't need to work heavily on DB; a person who has just started learning SQL or working on SQL can work easily using SQL developer.

SQL developer is not suited to a person who is a database administrator or works on creating big stored procedures, as it will feel laggy and supports fewer features.

Sushant goyal

Analyst in Finance and Accounting at Airtel International LLP-Airtel Africa (Telecommunications, 10,001+ employees)

Vetted Review

2 years of experience

View profile

Must-have SQL editor

Rating: 7 out of 10

Incentivized

April 12, 2021

Use Cases and Deployment Scope

Oracle SQL Developer is used across the company by different users depending on their preferences. Since it’s free, anyone can download and use it. It is best SQL editor for Oracle and other databases--lots of features and easy to use. It’s reliable and performs better than other similar tools. It helps database users to query, manage data in large enterprise databases like Oracle and Teradata. Oracle SQL Developer also has features for database migration, data modeling, data mining, import/export, versioning, analytics reports, change management, debugging, and logging.

Pros

Database querying SQL
Data modeling and design
Database explorer
Data filtering, export/import
Database object management
Data migration
Debugging
Version control
OLAP
Analytics reports
Sessions
Database comparision

Cons

Better user interface
Native support for other databases
Autocompletion
Performance

Likelihood to Recommend

It’s best suited if your company works with different databases and needs a common SQL editor to manage and query data for its user. Oracle SQL Developer works very well with Oracle but also some other relational databases. If you do lot of querying and import/export in database, then this is tool for you. It's ideal for DBAs as well for data modeling, management, session monitoring, logging, versioning, etc.

It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.

Verified User

Manager in Corporate (Telecommunications company, 10,001+ employees)

Vetted Review

9 years of experience

Easy to use tool for day to day needs - SQL Developer

Rating: 7 out of 10

Incentivized

April 9, 2021

Use Cases and Deployment Scope

Oracle SQL Developer used by different groups for running queries, scripting, and compiling packages and procedures, etc . It really helps to connect multiple database at same time and manage day to day activities for end user needs.

Pros

Build and analyze SQL queries by connecting multiple databases.
User friendly GUI and easy to navigate through various features easily.
Import data easily from text files, Excel files, and CSV files.
Easy to install and config.

Cons

It uses lot of system memory.
Lack of scheduling jobs.
Export or import data from on-prem to cloud and vice versa easily.
Nice to have drag and [desktop] feature.

Likelihood to Recommend

It is well suited to develop code and create new objects. It is well suited to view current data and alter based upon requirement.

Satishbabu Gunukula, Oracle ACE

Sr. Database Architect in Information Technology at Intuitive Surgical (Health, Wellness and Fitness, 1001-5000 employees)

Vetted Review

12 years of experience

View profile

Loading Reviews List....