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 Information Technology and Services

Mid-Market (51-1000 emp.)

10/22/2018

"comprehensive tool"

5/5

What do you like best about SQL Developer?

very practical and easy to use,; many useful features and simple to install Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

there isnt much to dislike. it's easy to use and well built Review collected by and hosted on G2.com.

Verified User in Oil & Energy

Mid-Market (51-1000 emp.)

2/3/2018

"Sql developer does not function well"

0.5/5

What do you like best about SQL Developer?

Its makes some of the ugly oracle issues go away, it has a good ui for the most part Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Alot. F9 vs f5 for starters. Reconnect option never works and software give no feedback. Many of ghe options aren't where they should be, crashes far far more frequntly than it should, consumes a hige memory footprint, will often times not let user cancel sn action, the sproc interface is garbage, for starters. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

If you have to edit an oracle db, Stick with toad, Its lighter weight and easier to use, and it doesn't crash. Review collected by and hosted on G2.com.

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

Connecting to oracle instancd for basic crud type operations. Mostly in support oc client dba staff of to supporf our own software products. Thd only benefit id that we didnt pay for it Review collected by and hosted on G2.com.

Claudia P.

Tecnico Senior

Enterprise (> 1000 emp.)

7/27/2018

"Very complete database"

4.5/5

What do you like best about SQL Developer?

It has a multitude of functions, allowing you to be connected to different databases at the same time. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

When you make very heavy queries, it gets stuck. Review collected by and hosted on G2.com.

Verified User in Financial Services

Mid-Market (51-1000 emp.)

4/10/2018

"Great application!"

4/5

What do you like best about SQL Developer?

It is very easy to add various connections, formatting for SQL is in-built, the query output is available in various the extraction of outputs to reports. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The choice of fonts and query output available. If a queries in a script are not terminated properly, and the query where the cursor is run, it executes the full script, and at times executes more queries than intended. Review collected by and hosted on G2.com.

Verified User in Primary/Secondary Education

Enterprise (> 1000 emp.)

9/18/2018

"Nice easy access"

5/5

What do you like best about SQL Developer?

It is easy to set up and use with an ODBC connection. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

There are some limits on connections. But that my be our deployment. Review collected by and hosted on G2.com.

Verified User in Government Administration

Enterprise (> 1000 emp.)

10/24/2018

"Excellent Database Client"

4.5/5

What do you like best about SQL Developer?

Easy to use to connect to any Oracle Database Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I don't really dislike anything about SQL Developer Review collected by and hosted on G2.com.

Chirag A.

Information Technology Analyst

Information Technology and Services

Enterprise (> 1000 emp.)

1/26/2018

"Great Software for writing SQL"

4.5/5

What do you like best about SQL Developer?

It is having very good Graphical User Interface along with a nice object explore. Also one can see all the transaction related statistics without even writing the command. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It is bit heavy and sometimes took time while reconnecting or restarting. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Sql developer is a great tool for writing SQL statements and creating PL/Sql stored procedures. I highly recommend this product due to its great graphical user interface and the auto suggestions. Review collected by and hosted on G2.com.

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

We have a project in which we are doing application development and if user report any issue then we need to analyze the data where we need to use SQL developer.

Also it is best suitable for Oracle DB and analyzing any data become easier via this tool. Review collected by and hosted on G2.com.

Scott M.

Software Engineer

Mid-Market (51-1000 emp.)

7/6/2018

"Good for a standalone database tool."

3.5/5

What do you like best about SQL Developer?

I like the tool as a standalone database tool for modifying tables and cells. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It doesn't have as many features as other database tools I've used in the past, but good overall. Review collected by and hosted on G2.com.

Verified User in Warehousing

Enterprise (> 1000 emp.)

9/22/2018

"The right tool for the right job"

4/5

What do you like best about SQL Developer?

Simplistic, guiding and efficient it gets the job done. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

A database source wizard would have been helpful when I first started out. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Small-Business (50 or fewer emp.)

6/1/2018

"Great environment to manage and query multiple databases"

4.5/5

What do you like best about SQL Developer?

Easy management of multiple connections to different databases. The learning curve is not steep and is really ideal for developers that just need to do simple actions like queries.. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

For more complex actions, it might not be the best. The intuitiveness of where certain actions should be isn't too great, and sometimes takes multiple clicks just to get there. Also, the autocomplete does not function properly pretty often. Review collected by and hosted on G2.com.