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 Investment Banking

Enterprise (> 1000 emp.)

8/5/2016

"SQL Developer Product Review"

4/5

What do you like best about SQL Developer?

It is easy to use and provides plugin to major vendors like Sybase , Oracle , MySQL and SQLServer. One can easliy view the table and its DDL structure.One can amend the data in bulk through the GUI provided.One can create and run stored procedures , triggers through SQL Developer also. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It works well with oracle but for Sybase tables i doesn't show the constraints and indexes of a particular table. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Please use this tool.The basic version is free and does most of the job needed for a SQL Programmer.It can run SQL Queries , enable you to view the table structure , amend the data in bulk and allow one to run queries on Sybase and MySQL tables as well.One can write stored procedures , triggers and views as well. using SQL Developer.It also allows one to import or export data in tables. Review collected by and hosted on G2.com.

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

I am currently working on an MIS Application for which I use SQL Developer for viewing tables and running queries and stored procedures. Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising

Mid-Market (51-1000 emp.)

9/8/2016

"Does what it needs to do"

4/5

What do you like best about SQL Developer?

The little limitation that SQL has on file size versus Excel, obviously! The interface is pretty simple but kind of archaic at the same time. It doesn't necessarily have to have a beautiful interface to be trustworthy but it might be less scary to novices/beginners. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

As somewhat of SQL novice, I don't like when there are errors, SQL doesn't show you how to fix them as it does in Excel. Perhaps that is part of the understanding with SQL, that you are expert enough to know where you code is broken. Review collected by and hosted on G2.com.

Sean S.

Oracle Database Administrator

Mid-Market (51-1000 emp.)

5/4/2016

"A decent basic SQL editor"

2.5/5

What do you like best about SQL Developer?

SQL Developer is a simple interface for basic coding and it has a robust set of customizations available, as well as integration with version control tools like git and SVN. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

As a OS X user, I find that there are a fair number of features that just don't work, or only work with extensive manual modifications to the code base. I'd prefer a tool that worked reliably out of the box.

For example, if you want to use the "Reset password" feature you have to install the separate Instant Client, then go in and edit the launcher tool to set paths correctly for Darwin. Simply put, if the tool is available for a popular OS, features should be tested and working or made unavailable until they are. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

It may be worthwhile to evaluate alternative tools if you're looking for something to do more than basic database queries. Review collected by and hosted on G2.com.

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

Sometimes a GUI is nice. We have a lot of non-database developers that use SQL*Developer as a means of connecting easily with the database, which simplifies their lives. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Enterprise (> 1000 emp.)

8/26/2016

"SQL Developer - integrated development environment"

4/5

What do you like best about SQL Developer?

1. Easy to install by simply unzipping the downloaded file and running the executable

2.Beneficial to users of alternative platforms

3.Client server network traffic can be avoided by using Oracle SQL Developer because users of Oracle SQL Developer can install this software on the Database server and the users can be remotely connected from their desktops

4.Oracle Home is not required while using Oracle SQL Developer as the connectivity to the database is via JDBC thin driver

5.It is free Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

1. Absence of the schema browser in SQL Developer

2.Absence of a Modeler and Data Modeling features Review collected by and hosted on G2.com.

Verified User in Internet

Enterprise (> 1000 emp.)

1/15/2017

"SQL Developer tools"

4/5

What do you like best about SQL Developer?

The tool has many UI icons and interfaces to build and execute queries. Also, the export/import features are nice. The prompts with the table/database/view name for accurate object names. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The connection hangs very often and needs to be reconnected. many times the application needs to be restarted and you might loose all your open data. this is very irritating. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

2/3/2017

"Convenient SQL Editor"

5/5

What do you like best about SQL Developer?

SQL Developer is a free sql programmer for oracle DBA.

It is very convenient and easy to use. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Data exporting in Microsoft Excel format does not work for huge data. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

8/30/2016

"A great companion to Oracle Database"

4.5/5

What do you like best about SQL Developer?

Native support to Oracle Database, has all the features that are needed for Oracle DB, free and powerful SQL IDE. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Support Oracle DB only. If you need to work across different DB engines, you have to use other tools such as Navicat. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

If you are using Oracle DB, that is the number one tool you should consider first. Review collected by and hosted on G2.com.

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

We are using SQL developer to manage database tables, triggers, procedures. We also use it to debug and test SQL statements. Review collected by and hosted on G2.com.

Verified User in Higher Education

Enterprise (> 1000 emp.)

8/12/2016

"Oracle SQL Developer"

5/5

What do you like best about SQL Developer?

Love Oracle SQL Developer. It is my tool of choice as a DBA and Programmer. There are so many different tools in this software package. I am a Mac user and I was very happy to see this. So easy to set up and use. Can't beat the cost too. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The one thing I would say is a disadvantage of Oracle SQL Developer is that it is memory intensive. I have a problem with memory hogs like this. Review collected by and hosted on G2.com.

Jan P.

Senior Software Developer

Internet

Mid-Market (51-1000 emp.)

3/30/2016

"SQL Developer as everyday tool"

2/5

What do you like best about SQL Developer?

It is one of the few IDE for PL/SQL development which can be run on OSX and Windows and it is trying to be real IDE not just notepad with syntax highlight (but still so much to achieve). Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Instability and plenty of annoying bugs, which leads to restarting SQL developer at least twice a day (and I'm not counting that it at least twice a day dies spontaneously) Review collected by and hosted on G2.com.