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

Small-Business (50 or fewer emp.)

5/1/2019

"Great IDE for SQL development "

4/5

What do you like best about SQL Developer?

It is very comfortable and easy to create table and schema.SQL query execution and retrieve of details is very user friendly Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Sometimes it is difficult to connect the DB to other application using ODBS driver .There may be confusion of several oracle SQL versions Review collected by and hosted on G2.com.

Verified User in Machinery

Mid-Market (51-1000 emp.)

2/1/2019

"Easy to use for a newbee"

5/5

What do you like best about SQL Developer?

This product is not hard to learn when you have never officially written code before. Linking tables and driving around in it isn't hard at all. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I don't like that there isn't an easy way to move your queries around if you have a lot of different tabs open. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

3/20/2019

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

"Used SQL server for over 4 years now"

4.5/5

What do you like best about SQL Developer?

It is very easy to use and the product is very reliable. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Nothing as such but they should make the Oracle certifications for SQL Developer cheaper . Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Very easy to use SQL tool. As long you are good at writing queries then it is easy to use the SQL Developer. Review collected by and hosted on G2.com.

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

SQL Developer is used as the core part of the ESB product we use. So this sits as the backbone of the entire architecture. Review collected by and hosted on G2.com.

Verified User in Government Administration

Mid-Market (51-1000 emp.)

10/26/2018

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

"SQL Developer Review"

5/5

What do you like best about SQL Developer?

What I like best about SQL Developer as compared to other software that is similar is that it is very simple visually. All the Schemas, query outptuts, and other formatting is focused on functionality instead of aesthetics. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

SQL Developer crashes a lot on my computer. When the connection is lost, I have to restart SQL Developer, as everything I have done does not get saved. Also, having many tabs open at a time can be problematic. However, these issues are common with other software as well, and I still prefer using SQL Developer over other products. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

SQL Developer is a great tool to use for those who are working heavily with database validation and query writing. 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 write queries to our database, as well as look at the packages and tables in the different schemas of our database. Review collected by and hosted on G2.com.

Anthony J.

Programmer

Mid-Market (51-1000 emp.)

7/6/2018

"Good IDE for PL SQL"

3.5/5

What do you like best about SQL Developer?

It allows you to save multiple database connections which comes in handy. The UI is clean and neat. You can use multiple filters on database objects. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

SQL Developer doesn't have a built-in "profiler" that allows administrators to "see" what's happening in the server. Even 3rd party profilers doesn't give you as much detail like it's competitor, MS SQL. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Give it a try. Develop in parallel with your current database. It requires quite a stiff learning curve. Review collected by and hosted on G2.com.

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

Cost. Some of our clients are migrating to Oracle because it's less expensive than MS SQL. But be very aware of the pros and cons. Have a thought about it. Review collected by and hosted on G2.com.

Verified User in Government Administration

Mid-Market (51-1000 emp.)

4/2/2019

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

"DB good tool for developers"

5/5

What do you like best about SQL Developer?

This relational DB it's very helpful and easy to work. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I'm not find anything to dislike this DB. It is wonderful to work and create queries Review collected by and hosted on G2.com.

Margiorie M.

Consultor

Information Technology and Services

Mid-Market (51-1000 emp.)

5/16/2018

" Easy to use and reliable"

5/5

What do you like best about SQL Developer?

It is an easy tool to use to perform the development of the different database components that are required, the component scanner is ideal for locating them. I always use it to program, debug and execute in a single environment what is needed. It allows me to efficiently and quickly manage users, permissions and profiles. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

In general I like to work with SQl developer, I think it should only improve the generation of DDL and database documentation Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

I highly recommend it, since it is really very easy to use and reliable, it does not present problems when developing the different components that are required for the database. Review collected by and hosted on G2.com.

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

With this tool I generate the components (Stored procedure, Types, Tables, etc) that are needed for the integration of BPM processes (Generate commercial credits, Credit cards, etc) with Soap services. It helps me resolve queries and updates from the front to the different Backend Review collected by and hosted on G2.com.

David L.

Director, IT Systems

Enterprise (> 1000 emp.)

10/22/2018

"Oracle SQL Developer"

5/5

What do you like best about SQL Developer?

I love the ability to interact with so many different databases and instances. It makes writing queries so easy -- especially with auto-complete suggestions. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The worksheets can become a bit cluttered. It would be nice if there was a way to collapse individual queries all the time. It does work sometimes, but certain query structures don't allow it. Review collected by and hosted on G2.com.

Verified User in Consumer Goods

Mid-Market (51-1000 emp.)

1/23/2019

"SQL Developer"

4/5

What do you like best about SQL Developer?

its a nice, well organized way to view the database, make queries or views, and edit the data Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I find the SQL language harder than most to get a good, easy grasp of Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

1/7/2019

"SQL Developer - Easy to use."

3/5

What do you like best about SQL Developer?

Great tool to run SQL statements and scripts.

you can get the data without any sql script in data tab and update if required.

It can handle large amount of data like oracle. you can create data models diagram very easily with this tool. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Oracle can improve the user experience.

also can provide script generator from data like SQL DBx. Review collected by and hosted on G2.com.