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.

Matt W.

AVP Data Engineering and Management

Mid-Market (51-1000 emp.)

9/17/2019

"Excellent functionality in 19C"

4/5

What do you like best about SQL Developer?

The Data miner extension is making this tool even more valuable for my organization! Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

More sample kits would be helpful for certain workflows of transforming data. Review collected by and hosted on G2.com.

Gerardo M.

Especialista de Proyectos TI

Mid-Market (51-1000 emp.)

1/30/2019

" excellent database manager"

5/5

What do you like best about SQL Developer?

Its ability to facilitate things through its interface and make an Oracle product facilitates calls to functions such as storage procedures that help facilitate the code with the programming language used. Considering the way to insert data so simple that allows you the sql developer and the use of relational database model

It makes it easy to provide solutions to specific ocular companies. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Constant errors when using the debugger in store procedures has many flaws and does not allow a good debug of functions or store procedures Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

The improvement of database management tools mainly of debugger is a very useful tool when programming and in the case of a database manager would be very good to have that tool for the best way to locate errors much more easy Review collected by and hosted on G2.com.

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

Solutions to companies at a national level in the country of Venezuela with its tools to create and relate tables with records that allow to store data of any application in which this tool is implemented

in companies such as telephony companies and private clients that need the technological solution in which the sql developer is necessary Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

4/15/2019

"One of the best tool for executing Select Queries, Updates, Delete or running any stored procedures"

5/5

What do you like best about SQL Developer?

One of the best tools for executing Select Queries, Updates, Delete or running any kind of complex stored procedures over the database. It's very easy to execute & can make any type of changes whatever required over the database. We build many complex stored procedures using SQL developer and completed our project successfully. It's very dynamic and performance wise it's too fast while comparing to others in execution any kind of commands. Any kind of data if we want to retrieve from the database we will use SQL developer for completing the task and export them using SQL developer into the required format. I really recommend this product to fulfill any kind of database related interactions. The best tool to use it over the organization level. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I didn't find anything wrong till now in my usage about this tool, whatever I executed till now using SQL developer it gave me the best in the execution. Really nice to have in my system. Once you implement this in your organization you will never regret or get disappointed about this. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

I really recommend this product to fulfill any kind of database related interactions. The best tool to use it over the organisation level. Review collected by and hosted on G2.com.

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

Any kind of data if we want to retrieve from the database we will use SQL developer for completing the task and export them using SQL developer into the required format. Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

4/5/2019

"Oracle SQL Developer is the best ERP tool"

5/5

What do you like best about SQL Developer?

We are using Oracle SQL developer for connecting to different databases which are available for our client and also a few different application databases which we are connecting. it's so user-friendly & databases which we are connecting for GUI setup is so simple with very basic understanding anyone can easily use the tool. For executing the queries & doing any database related operations it's so easy & helpful to use. whatever applications logs which are available in database tables & for validating the content in the tables, for viewing the data its so simple to verify. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I didn't find anything cons about this ERP tool, it's so user-friendly I can. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

I request everyone to use this ERP tool for any kind of database related interactions. its helpful in connecting different databases which are getting used for our clients & for validating the data which is available databses. whatever applications logs which are available in database tables & for validating the content in the tables, for viewing the data its so simple to verify. Review collected by and hosted on G2.com.

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

its helpful in connecting different databases which are getting used for our clients & for validating the data which is available databses. whatever applications logs which are available in database tables & for validating the content in the tables, for viewing the data its so simple to verify. Review collected by and hosted on G2.com.

Atif A.

Methods and Tools Engineer

Enterprise (> 1000 emp.)

4/8/2019

"It is the best software to export database. Free to download. Easy to use."

5/5

What do you like best about SQL Developer?

It is easy to start for new users and making connections are easy. The best thing is to filter tables and doing columns. It allows to export the database structures. We can the SQL execution history Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Debugging is difficult and finding out the errors is a bit difficult. It doesn't allow to store the procedures Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

It is the best available software for SQL queries.

Easy to install and setup. Review collected by and hosted on G2.com.

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

We are using SQL to run the queries and get the required data. We also use it update and delete the data in the database which is the best part of it. Review collected by and hosted on G2.com.

Verified User in Automotive

Mid-Market (51-1000 emp.)

9/18/2019

"Data Analyst"

4/5

What do you like best about SQL Developer?

The most helpful is external tables. It's very easy to use and can reference to master table easily.

I likely to recommend my friends to use it.

Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I am new to this, so far I am very happy with using the product Review collected by and hosted on G2.com.

Verified User in Entertainment

Enterprise (> 1000 emp.)

9/16/2019

"SQL Developer has been great so far."

4.5/5

What do you like best about SQL Developer?

SQL Developer has quick controls that is very useful for day to day usages for a Business Analyst and Technical Developers Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Sometimes its hard to find ways to use some of rarely used features Review collected by and hosted on G2.com.

Nilesh J.

Programmer

Small-Business (50 or fewer emp.)

9/16/2019

"nice product but memory management needs improvement"

3/5

What do you like best about SQL Developer?

Portable and free of charge

Portable and free of charge Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Memory consumuption is very poor frequent crashes Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

3/31/2019

"Best Tool for oracle database operations"

4.5/5

What do you like best about SQL Developer?

Its free! It provides interface for all PL SQL modules, Java procedures, HTML, XML etc. It supports all developer operations like create tables, triggers, packages etc .Its very useful for PL SQL Unit testing. The other nice feature is we can see multiple datagrids at a time for multiple queries ran in a query window. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Whenever I need to refresh connection to the server (it is time limited), I have to shut down the Developer completely and restart it. Review collected by and hosted on G2.com.