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 Telecommunications

Mid-Market (51-1000 emp.)

4/19/2018

"Good experience with some fallbacks"

3/5

What do you like best about SQL Developer?

I like the integracion that it have (full) with Oracle product. I has plenty of functionalities for beginners and pros, if you like to go a little more further i recommend other tool like Toad. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I dislike the incompatibilities between SQL Developer and (Java Version + Windows Version) that causes glitches on the gui. If you have some luck its a problem that will never reach you, but sometimes you need to change JDK used o touch some configuration to have it working properly (mainly on the gui) Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

10/26/2017

"Comparison of Oracle SQL Developer with some other same products in the market"

4.5/5

What do you like best about SQL Developer?

Saved Credential for users, Imp/Exp, GUI Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Its Slow, it Don't Remember my Condition Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

It is a good tools to play with data, but it is not very good in speed, The most painful is not keeping your where conditions saved to apply on other tables, rather you will have to write where condition again even you want to use the same where condition for other tables. Imp and exp command are not available for database. Other features are as good as in the other such products, like SQL Server , etc. Review collected by and hosted on G2.com.

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

1. As a developer I user it for Checking my data whether every column is updating correctly as per my code, 2. When users make mistakes I quickly fetch that data using it. 3. Create tables and Indexes for my projects. 4. Write Procedures. 5. Copy my sql command that I use in my programs and run in here to check for the syntax or other errors. 6. Show my clients users the data from here to proof many things like whether the data is updating correctly and that they have made mistakes in entries. etc. 7. In Short I must keep my SQL Developer window opened while writing database applications so that I can quickly check the reflections. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

7/5/2018

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

"Easiest language for developers"

5/5

What do you like best about SQL Developer?

Much easier than python. Can streamline and do more things better than R or Python. It’s comprinke with many other tools like excel. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I hate that if a syntax is incorrect it doesn’t tell you exactly what’s wrong Review collected by and hosted on G2.com.

Verified User in Oil & Energy

Mid-Market (51-1000 emp.)

4/24/2018

"Sub optimal DB management tool for a sub optimal DB(in most caese)"

1/5

What do you like best about SQL Developer?

The product is free, relatively easy to use. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

This product is extremely unstable, the default shortcuts are counter intuitive (based on many other popular management tools ) some of which cause the software to crash. It is extremely unresponsive, with no visual indicator as to why. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

12/13/2017

"one stop solution for all the database needs"

4.5/5

What do you like best about SQL Developer?

The user Interface is quite easy to interact with and very fascinating when it comes to manipulate with the data from the database Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

When we have to remotely access database through a VPN (virtual private connection) connection and somehow if we forget to turn on the VPN(virtual private connection) and connect to database through SQL Developer, it takes time to respond and crashes in a rare scenario like this. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

I highly recommend this software as it helps you to manipulate data and manage database connections with ease. Review collected by and hosted on G2.com.

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

As a software engineer, while fixing a bug we need query data to understand if the query is returning correct data or not. hence this helps us rectifying the problem. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Enterprise (> 1000 emp.)

4/30/2018

"SQL Developer"

5/5

What do you like best about SQL Developer?

I love the ease of use. I can query data in an extremely easy fashion using my organization's metadata Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

With not many Query tools to compare it too, it is difficult to say. I really enjoy the overall interface of this tool Review collected by and hosted on G2.com.

Verified User in Education Management

Mid-Market (51-1000 emp.)

6/10/2018

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

"Reviewing sql developer"

4.5/5

What do you like best about SQL Developer?

Excellent developer tool for connecting to oracle data sources Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Nothing to dislike, very user friendly.. Review collected by and hosted on G2.com.

Verified User in Music

Small-Business (50 or fewer emp.)

1/25/2018

"Great SQL tool!"

5/5

What do you like best about SQL Developer?

The graphical tree on the left showing all the schema objects is great. There are also many useful toolbar buttons, right-click menus and drag & drop features. You can also now create connections to cloud databases. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

SQL developer occasionally freezes and crashes. Also there is no way to terminate an executing PL/SQL program once it has started. Review collected by and hosted on G2.com.

Verified User in Education Management

Mid-Market (51-1000 emp.)

1/18/2018

"Useful tool for connecting to Databases"

3.5/5

What do you like best about SQL Developer?

Easy to install, queries run fast, and let you know when there is an error Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It is slow to grab fields for you, ie: typing a table or alias and loading a list of available fields to choose from. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

10/30/2017

"Sql Developer is very good free tool available for pl/sql development"

5/5

What do you like best about SQL Developer?

GUI is very good and it is helpful for developers to analyze the data and create a Entity Relationship Diagram. We can compare sql reports here. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

this should be more compatible for schema comparison. Review collected by and hosted on G2.com.