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.

Laura G.

Back End Developer

Enterprise (> 1000 emp.)

7/27/2018

"Great IDE for sql "

3.5/5

What do you like best about SQL Developer?

It helps you organize different connections and even you can divide it with folders. It's fas and easy to use, very intuitive. You can filter your information and even the name of the tables, I like the function very much. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It's only useful if you use an oracle database. It might be a little slow if your script it's veeeeery long. Sometimes you have to adapt the query to oracle based sql. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Great option to organize your database if you use an oracle one. Review collected by and hosted on G2.com.

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

At work, we use it to connect with different databases based on oracle. It's easy to use. We use it to consult data of our applications. Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

1/4/2019

"Good tool to browse Oracle database "

4/5

What do you like best about SQL Developer?

Able to save multiple db connections and sql scripts. I work in multiple VPNs to connect to different environments. The reconnect options works fast compared to other SQL Query tools. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

nothing really. I like this tool as it is fast in mac os. Review collected by and hosted on G2.com.

Gustavo A.

Board of directors member

Higher Education

Small-Business (50 or fewer emp.)

1/30/2018

"Useful tool for basic SQL"

3.5/5

What do you like best about SQL Developer?

SQL Developer is very useful to organize different connections (Oracle databases). It's easy to use, intuitive and clean design. It has plenty plugin users.

It's free.

In terms of SQL developing it's a tool that offers the developer everything needed. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Quite slow and not so useful if you are not using an Oracle Database.

If you want to edit a table the process is not so quick as it should.

It has to improve some export tools (Excel tables, e-mail connection). Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

If you are starting with SQL, SQL Developer is good starting point.

If you are using for professional purposes, more advanced level, the tool gives a lot and almost everything needed and it's free. Review collected by and hosted on G2.com.

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

To develop the application I am working on at the moment, I need to get information and cross it with different databases. SQL does the job.

I also use it to Data management of different applications. Review collected by and hosted on G2.com.

Verified User in Higher Education

Mid-Market (51-1000 emp.)

10/24/2018

"I Love SQL Developer great product"

5/5

What do you like best about SQL Developer?

I like that it is free, its a great tool and at no cost. I work in Higher ED and buying new tools is hard. This one is free so i dont need to get approval. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I seem to use the same features all the time. I would like to begin using it more and in different ways. But i dont know where to begin. I wish there were more short tutorials about different features. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

2/6/2019

"Why we should we use Oracle SQL Developer?"

5/5

What do you like best about SQL Developer?

Its easy and convenient. The data tables are well defined in the diagrams and connecting to SQL server is easy. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Sometimes there are hangups and sudden connection loss. Review collected by and hosted on G2.com.

Verified User in Machinery

Mid-Market (51-1000 emp.)

10/23/2018

"SQL Developer"

3/5

What do you like best about SQL Developer?

Ability to quickly establish a connection to the database to test connectivity. Ability to call sql developer from linux to troubleshoot issues. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The interface is not very user friendly. Would be nice to be able to select the database being connected to from a list of values instead of having to type it. Review collected by and hosted on G2.com.

sandeep n.

Mid-Market (51-1000 emp.)

10/22/2018

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

"sql developer review from development perspective"

2.5/5

What do you like best about SQL Developer?

sql developer works well with ORDS as well Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

sql eveloper is fat client and has download client on desktop Review collected by and hosted on G2.com.

Stanley J.

Business Intelligence Manager

Higher Education

Enterprise (> 1000 emp.)

12/6/2017

"SQL Developer is a good option for keeping up with multiple Oracle Databases."

4/5

What do you like best about SQL Developer?

I like that I can quickly organize multiple connections and get to them with a simple double click. The Auto-fill for packages, procedures, and functions helps write queries quicker with such a large code base. The sort and filter options in the results is also a great feature. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I would like the ability to drag column headers into queries from the results section. That is one function I believe would make the product better. SQL Dev also tends to be a bit resource hungry and can take a good bit of time to load on occasion. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

There are a lot of other products out there for managing and querying databases. This works particularly well for us, as we also primarily use Oracle Databases. Take a look at the nice integration with other Oracle systems, as I believe that's where this product truly shines. Review collected by and hosted on G2.com.

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

I use SQL developer to query my data warehouse and other data sources I have access to. I use these queries to define data sets for use in analytics and also do auditing between data sources. Review collected by and hosted on G2.com.

Suhasini B.

Student Technical Assistant

Higher Education

Enterprise (> 1000 emp.)

4/19/2018

"My experience with SQL Developer"

4.5/5

What do you like best about SQL Developer?

The best thing about SQL Developer is one of the best IDE. It has variety of plugins, includes easy design. It connects to all oracle database. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It becomes slow and hangs for a longer period of time. It doesn't load when big output needs to be delivered. Review collected by and hosted on G2.com.

Verified User in Government Administration

Enterprise (> 1000 emp.)

10/23/2018

"Excellent free Tool"

4.5/5

What do you like best about SQL Developer?

The ease of managing and querying the database objects. The best is the admin queries and the pictorial view. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The java based tool hung sometimes, and I need to restart the tool. If this can be fixed then its the best bet to replace the third party tools. Review collected by and hosted on G2.com.