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.)

9/16/2019

"This gui help to quickly identify issues with production db"

4.5/5

What do you like best about SQL Developer?

I like the feature that allows to view of dba administrator functions Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It doesn't have the same feature as toad. Review collected by and hosted on G2.com.

Jonathan A.

Analista BPM semi senior

Small-Business (50 or fewer emp.)

2/15/2019

"A practical tool for the DB development"

5/5

What do you like best about SQL Developer?

There are several aggregates that despite not being Oracle can be supported by it.

The execution of queries and stored procedures is very fast and effective Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Maybe could improve the resource manager and the storage. Sometimes they are not really intuitive and can be improved in this point. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

It is a strong tool with what is worth investigating on how to maximize your capacity. Review collected by and hosted on G2.com.

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

The main problem was often found by having a bad database model. But that is not related to the tool but to the architecture implemented by the client. So and all this offers a good information handling Review collected by and hosted on G2.com.

Verified User in Oil & Energy

Enterprise (> 1000 emp.)

9/16/2019

"Ease of Use"

3.5/5

What do you like best about SQL Developer?

Easy to setup data connections, and psql functions. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Cannot connect to non oracle databases. This results in needing several applications for a complex database environment. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

9/19/2019

"SQL Developer nice db access/reporting tool"

4.5/5

What do you like best about SQL Developer?

SQL Developer GUI interface is well organized and looks sleek. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

SQL Developer GUI interface is less flexible/adjustable than Toad Review collected by and hosted on G2.com.

Verified User in Financial Services

Mid-Market (51-1000 emp.)

9/17/2019

"SQL Developer"

1.5/5

What do you like best about SQL Developer?

Seeing the cost of running sections of the code Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

bad autocomplete, feels clunky to run scripts vs sections Review collected by and hosted on G2.com.

Verified User in Design

Small-Business (50 or fewer emp.)

8/10/2019

"Love Developer for design data"

4/5

What do you like best about SQL Developer?

Me and my colleagues love the ease that developer brings Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Its difficult to learn the language but once done so developer allows for great data grabbing Review collected by and hosted on G2.com.

Prashant S.

Consultant

Enterprise (> 1000 emp.)

8/14/2018

"Great tool to execute SQL on any database"

5/5

What do you like best about SQL Developer?

It has a good interface and also we can get list of all SQL executed in history section.

It has explain plan which is of great help.

Also now we can manually specify the TNS file path which is of great help to developers.

In recent release its ability to connect to cloud dB. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The result which we get after executed should be saved in a csv. It get lost if we run another query.

We should have history of result set.

Also it should have excel like feature to sort and filter result set. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

11/25/2018

"Review for SQL Developer"

5/5

What do you like best about SQL Developer?

SQL Developer is an extremely useful application for management and development of databases. It allows you to perform all the possible tasks you need to work with databases. Writing a query is really simple and help is easily available if you are stuck anywhere. You can code, test and debug using this one application itself. It also allows you to integrate with multiple databases. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

When you execute long queries with many joins in them, SQL Developer works really slow or even freezes at times. You have to end up killing it in and writing the query again if you had not saved it. It would be nice to have an option of saving old results even after we execute a new query. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

One of the best applications for analyzing database systems 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 our CRM application database to understand the relation between various fields and how they are related to various other tables. I use this information to analyze and provide a fix to any problem faced on our application. Review collected by and hosted on G2.com.

Ajay M.

ERP Consultant

Information Technology and Services

Enterprise (> 1000 emp.)

4/18/2019

"SQL dev"

5/5

What do you like best about SQL Developer?

Ability to connect with databases and supports multiple connections Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

SQL developer does a poor job is handling large datasets, exporting data for rows > 2000 is quite troublesome. Review collected by and hosted on G2.com.

Verified User in Financial Services

Mid-Market (51-1000 emp.)

1/2/2019

"SQL developer"

4.5/5

What do you like best about SQL Developer?

Easy to use, allows multiple connections and easy to switch between connections, opens up different worksheet for each connection. Simple to use for SQL beginners. Commits are easy within a click away for truncates/table updates. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Exporting values from the table is very slow. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

It is free tool and can be used by both Development and QA teams for manual and qa automation testing. Allows to export the results into different formats like excel, text file etc. Review collected by and hosted on G2.com.

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

We use this to do tables comparison with different versions of code for regression testing saving us time to manually test all combinations of test cases. We have developed PL Stored Procedures for tables comparisons expanding our regression testing scope not to miss any scenarios. It is free ware. Review collected by and hosted on G2.com.