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.

Verified User in Computer Software

Enterprise (> 1000 emp.)

1/18/2016

"Intuitive and Free SQL Tool"

4.5/5

What do you like best about SQL Developer?

While the license of SQL Developer is a proprietary license by Oracle, it is a free product. It is very easy to pick up and get started with intuitive tools and user interface. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Like some of the other tools from Oracle, the software can be a bit buggy and crash often. I've noticed this using the SQL Developer software on Mac OSX. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Since it's free, it's definitely recommended to give it a download. Take a look at the various plugins that are available since it can expand the functionality of the software. Review collected by and hosted on G2.com.

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

I've been using this tool with various clients to manage some simple relational databases. Since it's a completely free product, I can throw it on all of my machines when I need to manage the database side of the projects. Review collected by and hosted on G2.com.

Verified User in Import and Export

Enterprise (> 1000 emp.)

5/31/2016

"SQL Developer Review"

5/5

What do you like best about SQL Developer?

Easy to use, rarely ever have problems with it crashing etc Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Only wish that there was an easier way of organizing the various scripts that I have. I usually jjust comment them out. Review collected by and hosted on G2.com.

Verified User in Automotive

Enterprise (> 1000 emp.)

1/11/2016

"Powerful Database Tool that grows with you"

4.5/5

What do you like best about SQL Developer?

I've been able to connect to several variants of databases with a single installation of Oracle SQL Developer.

By utilizing the External Plugins DLL extension, I've successfully used this tool to interface with IBM DB2, PostgreSQL, Oracle DBs, MySQL, Sybase, SQLServer, and Access.

Whatever you throw at this thing, you can find a way to connect to your database.

The UI is easy to walk through and once you learn how to pin tables, it is an easy tool to compare tables side by side. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Installation was not as straight forward or out-of-the-box.

Plugins can be a little tricky at first and may take a few tries to get configured correctly.

It would be great if there was an easier way of sharing connections with colleagues to allow for quicker team set up. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

12/15/2015

"more than five years to take use of this tool"

4.5/5

What do you like best about SQL Developer?

manipulate many multiple databases at the same time, that's great for us to work on different environments. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It took too much memories even if only open one tab. Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising

Enterprise (> 1000 emp.)

1/18/2016

"User friendly"

4.5/5

What do you like best about SQL Developer?

The Interface is very user friendly, its pretty easy to figure out for a first time user. I use the built-in filter feature a lot and the fact that I can connect to and query multiple instances of databases on the same interface is nice. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It can get too slow some times. Throws weird errors when connected for too long Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

1/8/2016

Business partner of the seller or seller's competitor, not included in G2 scores.

"Easy and Quick from installation to learning and using!!"

4/5

What do you like best about SQL Developer?

This is peobably the first and the oldest tool i have worked upon. I really had no learning curve. It easy and free to install. It allows you to connect to your database with any complications. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The only thing that i did not like was that there have been absolutely no major improvements. Its been the same for a few years now. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Its way better than many other free or cheap softwares available in the market.

This is worth giving a try.. Review collected by and hosted on G2.com.

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

We used it for campaign management.

It helped in developing, executing, prioritizing and reporting multi-channel based campaigns to successfully acquire/retain and enhance revenue. Review collected by and hosted on G2.com.

Brad K.

Software Developer and Consultant

Computer Software

Small-Business (50 or fewer emp.)

7/15/2015

Business partner of the seller or seller's competitor, not included in G2 scores.

"Great product for multiple database technologies."

5/5

What do you like best about SQL Developer?

Despite being developed by SQL Developer allows users to easily manage connections Oracle databases as well as to a multitude of database technologies such as SQL Server, Mysql, and Teradata through third party plugins. The tool is very intuitive, and you can't beat the free price. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

After idling for a long time, the application will occasionally stop responding and the user may be forced to quit. A similar problem exists when refreshing connections to a database after the connection times out. It can be a hassle to restart the application. Review collected by and hosted on G2.com.

Roger C.

Senior System AnalystSenior Sys

Computer Software

Enterprise (> 1000 emp.)

4/10/2015

"Developing oracle applications with SQL Developer"

4/5

What do you like best about SQL Developer?

The tool was very intuitive to use. There was only a small learning curve before a new user could be very productive. Menus contained the items you'd assume would be under them. Icons reflected the actions they represented Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It was possible to display too many icons, too many menus, too many windows. The screen became intimidating. Even experienced users could become lost. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Given a basic understanding of Oracle and SQL, this product should be an immediate help to developers and business users. Establishing this as "the" SQL tool for a team of developers increases the benefits you can reap from it. Review collected by and hosted on G2.com.

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

The project was to merge legacy data into the current oracle database. We needed to not only create scripts to accomplish the merger, but to also be able to validate that other data merges were successful. Being able to create and populate tables on the fly saved a lot of time. Many of the functions were needed to use were already available to us. Review collected by and hosted on G2.com.

Arvind K.

PLM Consultant (Windchill) Senior Software Engineer

Mechanical or Industrial Engineering

Enterprise (> 1000 emp.)

12/25/2015

"User of SQL Developer"

3.5/5

What do you like best about SQL Developer?

I Like sql developer but the problem is I did not felt that it has some unique features..later I started using Toad Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

No Major improvements in the software since long. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

1/18/2016

Business partner of the seller or seller's competitor, not included in G2 scores.

"Oracle SQL Developer"

5/5

What do you like best about SQL Developer?

Free. Tool that is easy to configure. Used for running queries, developing PL/SQL, database management, etc. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Quite heavy to install. Hogs memory. Cannot run on mobile devices (so far as I'm aware of). Review collected by and hosted on G2.com.