SQL Developer Reviews & Product Details

Oracle SQL Developer is a free, integrated development environment (IDE) designed to simplify the development and management of Oracle Databases across both traditional and cloud deployments. It provides a comprehensive suite of tools for PL/SQL application development, database administration, data modeling, and migration from third-party databases to Oracle. With over 5 million users, SQL Developer enhances productivity by offering a user-friendly interface for tasks ranging from running queries and scripts to debugging and testing PL/SQL code. Key Features and Functionality: - PL/SQL IDE: A full-featured environment for writing, compiling, debugging, and testing PL/SQL applications. - Database Administration: Tools for managing database performance, security, storage, and configurations. - Data Modeling: Capabilities to create Entity Relationship Diagrams (ERDs), generate reports, and perform SQL and DDL scripting. - Migration Platform: Facilitates the migration of databases from platforms like Microsoft SQL Server, Sybase Adaptive Server, IBM DB2, MySQL, Microsoft Access, and Teradata to Oracle. - Multiple Interfaces: Offers desktop, browser-based (Database Actions), and command-line (SQLcl) interfaces to cater to diverse user preferences. Primary Value and User Solutions: Oracle SQL Developer addresses the complexities associated with database development and management by providing an all-encompassing toolset that streamlines workflows. It eliminates the need for multiple disparate tools by integrating essential functionalities into a single platform, thereby reducing development time and operational costs. Its support for various interfaces ensures flexibility, allowing users to choose the environment that best fits their needs. Additionally, the migration capabilities simplify the transition from other database systems to Oracle, facilitating a smoother integration process.

Seller

Oracle

Discussions

SQL Developer Community

Overview by

divi kumar (Embedded Hardware Engineer at L&T Technology Services Limited)

Value at a Glance

Averages based on real user reviews.

Time to Implement

1 month

Return on Investment

7 months

View More Pricing Information

Top-Rated Alternatives

View All Alternatives

SQL Developer Media

SQL Developer

G2 reviews are authentic and verified.

Here's how.

Yusoof A.

Database Team Lead

Enterprise (> 1000 emp.)

1/28/2024

"User Friendly Interface"

5/5

What do you like best about SQL Developer?

SQL Developer is very easy to install, setup and integrate with existing databases. I use it almost everyday. I really like the play button that is used to execute the procedures and packages without having to write additional blocks of code. There are buttons to clear your query screen and your output screen that are very helpful. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Multiple settings are needed to configure Format option. It would be better if they provided few templates to choose with preview rather than these settings. Review collected by and hosted on G2.com.

Megha K.

Enterprise (> 1000 emp.)

1/16/2024

"Best IDE for SQL and Oracle Databases"

5/5

What do you like best about SQL Developer?

SQL Developer is easy to use, handy tool. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Heavy IDE that takes a lot of memory to start. Review collected by and hosted on G2.com.

Deepak A.

Software Engineer

Mid-Market (51-1000 emp.)

4/26/2024

"The best SQL tool ever"

4.5/5

What do you like best about SQL Developer?

We can connect to many servers at once and work on them simultaneously. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Nothing to dislike, everything is good and works smooth. Review collected by and hosted on G2.com.

Shreya .

Package Specialist

Enterprise (> 1000 emp.)

11/16/2023

"Robust tool with various advantages"

4.5/5

What do you like best about SQL Developer?

User Friendly Interface,SQL Coding and Editing,Database Administration tools & Integration with Oracle products Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It's an intensive resource with a steep learning curve and have limited non-oracle database support Review collected by and hosted on G2.com.

What problems is SQL Developer solving and how is that benefiting you?

Transferring data between different databases, importing/exporting data in various formats, and managing data movement within Oracle databases. Performing administrative tasks such as user management, schema comparison, indexing, backup and recovery, and monitoring database performance. Generating reports and visualizing data using graphical tools within SQL Developer, allowing users to analyze and present data in a more understandable format. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

11/12/2023

"Development tool to handle data base"

5/5

What do you like best about SQL Developer?

SQL Developer tool provide an integrated development environment to handle SQL commands on the platform.

It is user friendly and easy to use.

This platform provide an environment wher we can execute our SQL command to handle the data in database. Her we can connect to the Oracle data base and handle the tables database in it.

It is platform indipendent and user friendly platform.

Error fixing and customer support is quite good when compared to other platform.

We can also use a option to export or import the data in database. Using this feature we can export data and import in other Oracle database by importing the exported file in it.

We can also use the backup functionality to backup the data from loss.

Here we can also share or send the sql commands we execute in one system to other system by saving the sql file. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

There is no dislike as per the platform but some time faced issue to connect data base. Review collected by and hosted on G2.com.

What problems is SQL Developer solving and how is that benefiting you?

I can easily connect database and use the data in it.

The IDE is platform indipendent and can use the integrated development environment functionality wher we not need to write entire command it will automatically popup the next executable commands or provide the options to select.

I can easily find errors and fix it. I can use this tool in mac and windows.

I can easily write the sql commands and handle the methods storprocedure and indexes easily.

The main problem I solved using this developer tool is it is a user friendly tool to connect and maintain database wher I can create user login as well.

I can easily save the commands that I executed to handle the database by saving the file and send to my local and open it in other PC or laptop.

I use the functionality of import and export the data base from one device to other in a simple and faster way by using this tool.

This tool also provide the backup functionality to backup the database on the shedule manner we select. Review collected by and hosted on G2.com.

Lisandro F.

Data Engineer Sr Consultant

Mid-Market (51-1000 emp.)

9/12/2023

"All required features in a single free tool"

4.5/5

What do you like best about SQL Developer?

SQL Developer is very simple to install and use, while includes dozens of features that allow you to connect, design, develop, monitor and administer an Oracle database. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Being a JAVA application, sometimes it is slow to open new tabs and performing some actions at UI level compared with native compiled tools. Review collected by and hosted on G2.com.

Daniel F.

Programming/Analyst

Enterprise (> 1000 emp.)

4/1/2017

"Best SQL IDE out there!"

4.5/5

What do you like best about SQL Developer?

SQL Developer integrates everything I've ever wanted or needed to do developing in SQL. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

There's an occasional time that a query/process won't be able to be stopped and I must kill the application. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

It's a highly used software, and for good reason. I believe it's the best SQL IDE available. I can quickly work through it creating my SQL scripts. I feel very enabled using it. Review collected by and hosted on G2.com.

What problems is SQL Developer solving and how is that benefiting you?

Quick development of SQL scripts with built in tools to create tables/links/synonyms, etc. Review collected by and hosted on G2.com.

Chandan T.

Software Engineer

Mid-Market (51-1000 emp.)

10/5/2023

"Simplest tool for querying multiple DB"

5/5

What do you like best about SQL Developer?

Pretty simple and straightforward.

Jdbc driver upload option is fine and simple.

SQL script writing and result exporting options.

Built-in feature to write/update data without having knowledge of SQL language Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Nothing in this tool to be disliked. It has got almost everything what a developer would require. Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

2/14/2024

"Easy to use open source tool"

5/5

What do you like best about SQL Developer?

It has been around for very long & hence has huge support base. It is the go to tool for connecting with Oracle database. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Export functionalities are limited and sometimes few excel functionalities do not work. Review collected by and hosted on G2.com.

Sheraz A.

Professional Freelancer

Mid-Market (51-1000 emp.)

10/6/2023

"SQL Developer your Database Solutions"

5/5

What do you like best about SQL Developer?

SQL Developer give you dynamic data management solutions, he use different keys like primary, foreign key to make the smart solutions for getting data from database as early as possible to accomodate user requirements, He use different tools to create database which be managed easier Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

If manual procedure adapt to create database it will affect the data performance and fetching and database management after deployment it's difficult to reengineering the database Review collected by and hosted on G2.com.