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 Integrations

(1)

Integration information sourced from real user reviews.

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

11/23/2021

"Best data modeling tool"

5/5

What do you like best about SQL Developer?

IntelliSense, highlight errors, provide autosuggestions Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It does not notify that the WHERE clause is missing in the UPDATE command. Review collected by and hosted on G2.com.

Alisson S.

Trainee

Mid-Market (51-1000 emp.)

11/19/2020

"Ease of use for SQL"

4/5

What do you like best about SQL Developer?

I like the layout of the application, buttons, menus on my first use it was not difficult to find me. The shortcuts I use a lot, have a lot of customization tools and have added a lot to me. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I had a problem with a table with Clob of the system (passes up to 8 thousand characters) sometimes in the select it hangs even bringing less data. I even did a test that ran only the developer and passed, so I believe it is something from my memory, but I could have some feedback from this freeze. I already did a test and left the application open and 1 hour went by without response. Review collected by and hosted on G2.com.

Verified User in Computer Hardware

Mid-Market (51-1000 emp.)

4/24/2021

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

"User Experience of Sql Development Tools"

4.5/5

What do you like best about SQL Developer?

The best part of this is that you can write complex queries and fetch data according to your needs. Stored a large amount of data according to your industrial needs. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The only problem that I have seen in this there performance. When there is vast amount of data stored table, then the performance of fetching data decreases. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Please try at least once if you have a huge Volume of data and you want to manage it in tabular form. Review collected by and hosted on G2.com.

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

Our enterprise application use SQL server to store our data. so we as a sql developer works to write complex queries to get data from there as per the business requirments. Also it provide the feature of reportings. so we don't have to depend on other BI tools Review collected by and hosted on G2.com.

Verified User in Oil & Energy

Enterprise (> 1000 emp.)

3/18/2021

"SQL Developer - My best IDE friend"

5/5

What do you like best about SQL Developer?

It is very simple to use and intuitive. It also has a clear structure, so anyone who works in SQL Developer has a complete picture of the database objects. One of the best parts of SQL Developers is snippets. It is a very practical way to have parts of the code at hand. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

There is no multi-filter function (creating multiple filters and applying when you want). Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

If you want to be agile when developing solutions in PL/SQL, SQL Developer is your best friend! Review collected by and hosted on G2.com.

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

I am developing DB schemas, creating DDLs and DMLs, testing procedures and functions, creating reports, etc. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

9/2/2021

"Excellent"

5/5

What do you like best about SQL Developer?

Ease of use. It's excellent software. Very easy to use and can customize as we want. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Sometimes glitches. It can get stuck, and then you have to restart. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

9/2/2021

"Oracle Database Viewer ,SQL editor, Query debugging"

5/5

What do you like best about SQL Developer?

Capability to debug the queries ,stored procedures Easily,Tools for Writing the queries like highlighting the Queries syntax and auto format of code . Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

This product does not have any particular dislikes Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

8/24/2021

"Review- sql developer"

4.5/5

What do you like best about SQL Developer?

As a developer this was the best tool for building custom applications Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Version changes and integration was little tricky Review collected by and hosted on G2.com.

Ankur S.

Associate System Engineer

Enterprise (> 1000 emp.)

7/26/2020

"Oracle SQL Developer Review"

5/5

What do you like best about SQL Developer?

The best thing i like about Oracle SQL Developer is its user interface . It has easy to use platform including its navigation to different features , connectivity to different local environments . Also , different schemas can e handles with ease . Also , the installation process is pretty simple . Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I have not found any cons as of now . It gets me all the basic work done. The only point can be its heaviness as it consumes more RAM . Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Its a easy to use platform providing all the features that one expect . Review collected by and hosted on G2.com.

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

I am using Oracle SQL developer in verifying GUI data with the database . Also using oracle SQL developer with selenium automation like fetching otp from the database , modifying data from backend etc . Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

1/16/2021

"SQL Developer - Oracle DB IDE"

5/5

What do you like best about SQL Developer?

Oracle is the widely used database as SQL Developer is a nice IDE in many ways which includes :

- It makes very easy to explore the database objects definitions eg: Tables, Views, Packages etc.

- It makes very easy to export data on files.

- Convenient to debug PL/SQL procedures. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

As soon as a running query is cancelled before finishing, it resets the DB connection sockets which hangs the tool for a few seconds. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

One of the top tool to make your life easy if Oracle DB is part of your tech stack. Comes handy in all the stages be it development, deployment or support. Review collected by and hosted on G2.com.

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

- To explore data using the query engine.

- To make DDL queries. Review collected by and hosted on G2.com.

Vipul J.

Product Engineer

Enterprise (> 1000 emp.)

11/2/2016

"Good Tool. Does the Job. Prefer PLSQL Developer "

3/5

What do you like best about SQL Developer?

Has a nice export query result functionality which supports exporting results to csv, xls, as well as a loader script. Easy to use UI. Provides nice to have interface for accessing DBA objects if you have DBA privileges. Has easy integration with version control tools such as GIT and SVN. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Not so stable and lags if the query is taking a long time to execute. Hangs if query execution is stopped before completion of a time-consuming query. Cannot keep the application window open for a longer time as the application will stop responding and you will have to restart the application. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Free and comes with oracle installation. Has almost all the features which a Developer would need. Not fancy though. If you have a choice, go for Toad or PLSQL Developer. Review collected by and hosted on G2.com.

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

As I have worked in the Financial Domain, most of the business logic resided in the backend. Creating MIS daily and quarterly reports for a major financial institution is the main business goal for our project. SQL Developer has inbuilt features which help in performance tuning of the application. Provides explain plan window as well other query analyser features which are useful for performance tuning of the queries. Review collected by and hosted on G2.com.