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

Enterprise (> 1000 emp.)

3/20/2018

"Perfect light weight dB access tool"

5/5

What do you like best about SQL Developer?

Lightweight and not resource intensive like other dB access tools Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The level of explain plan representation is not comparable with toad Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

10/24/2017

"Great tool"

3.5/5

What do you like best about SQL Developer?

Easy to use and very effective features to use for a database. The GUI is very good and it offers best competition to other database clients such as Toad. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Nothing much to dislike but adding other new features is greatly appreciated. Review collected by and hosted on G2.com.

Apeksha G.

UAT Analyst

Information Technology and Services

Enterprise (> 1000 emp.)

9/20/2017

"Ease of work with SQL Developer "

4.5/5

What do you like best about SQL Developer?

The easy to use interface makes your tasks easier. I also like the intellisense technology that gives you recommendations for auto-complete. It helps you save time Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It can use some advanced features as present int the tool TOAD Review collected by and hosted on G2.com.

John T.

Client Support

Information Technology and Services

Enterprise (> 1000 emp.)

1/25/2017

"Useful for using Oracle, make sure your JAVA is in order."

3.5/5

What do you like best about SQL Developer?

It connects up to all of our Oracle databases, and it has a native client for every platform. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I hate that by default it only loads 50 rows at a time. Also some bits are not very intuitive, or force the query to run a second time, for example trying to export data that was already displayed on your screen. This can be an extra pain for long queries. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Make sure you have the latest JRE and JDK installed prior to installing it. If you only want to run one database tool, it does support plugins to allow you to connect to other data sources. I don't find it as intuitive as some other clients, but its common usage means there is a lot of documentation out on the web. Review collected by and hosted on G2.com.

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

Troubleshooting database information within technical support. It works well and helps us find and analyze things. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

1/16/2018

"Good SQL client"

4/5

What do you like best about SQL Developer?

Best tool for connecting Oracle database server Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Nothing much to dislike, but preferred to have inbuilt support for other database like mysql and db2 Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Small-Business (50 or fewer emp.)

1/3/2018

"Free tool for sql development"

5/5

What do you like best about SQL Developer?

This is free available and support all oracle new feature for development and testing. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

data modeling is not advance and ER diagram is not good. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

10/24/2017

"SQL to create reports"

4/5

What do you like best about SQL Developer?

reliability and consistency are two great attributes Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

sometimes it seems like the error messages are not accurately informing me of my mistake in my syntax Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Enterprise (> 1000 emp.)

12/27/2017

"Sql"

4/5

What do you like best about SQL Developer?

I like the warehouse and how easily Oracle could be integrated across applications. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I think the language is quite limited. It is a bit different than Microsoft which was a change for me when I transitioned. Review collected by and hosted on G2.com.

Verified User in Higher Education

Enterprise (> 1000 emp.)

12/6/2017

"SQL Developer Reporting"

4/5

What do you like best about SQL Developer?

SQL Developer is a great beginner product for someone who is trying to learning SQL writing. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Very basic. Could add more functionality for those who are trying to do more advance SQL writing. Review collected by and hosted on G2.com.

Robby T.

Prospect Development Analyst, Senior

Higher Education

Enterprise (> 1000 emp.)

1/24/2017

"Great Data Extraction for Non-Profit Database"

4.5/5

What do you like best about SQL Developer?

This software enables me to easily connect to my database and extract the specific information I need. I am able to join many different table and query based on many different criteria. The software program allows me to use long lists of criteria entries as well. It is intuitive, well organized and and fast. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The password interface to connect to different database instances could use some work to be more intuitive and easier to change or lookup forgotten passwords. Review collected by and hosted on G2.com.