The G2 on SQL Developer

SQL Developer Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users find SQL Developer to be an easy-to-use tool with a user-friendly interface and helpful shortcuts. (6 mentions)

Users value the ease of accessing and managing databases with SQL Developer, thanks to its robust support and features. (2 mentions)

Users value the easy integrations of SQL Developer, praising its simple setup and ability to connect multiple databases seamlessly. (2 mentions)

Users appreciate the intuitive syntax and user interface of SQL Developer, enhancing their data manipulation experience. (1 mentions)

Users value the flexibility of SQL Developer, appreciating the user-friendly interface and code management options. (1 mentions)

Users occasionally face connection issues with SQL Developer, which can affect their overall experience. (1 mentions)

Users find the export functionalities limited, with various Excel features not functioning as expected. (1 mentions)

Users find the inflexibility in configuration settings cumbersome, preferring easy templates and preview options instead. (1 mentions)

Users find the ineffective session termination feature frustrating, making it difficult to manage long-running SQL executions. (1 mentions)

Users struggle with performance issues in SQL Developer, noting its heavy memory usage upon startup. (1 mentions)

Top Rated SQL Developer Alternatives

RaimaDB

Visit Website

Arpit K.

Associate Data Engineer

Mid-Market (51-1000 emp.)

5/16/2024

"An amazing data analysis and management tool"

5/5

What do you like best about SQL Developer?

As an SQL developer I really like to play with data. It is good and easier to use SQL . The best part in SQL is it's syntax and UI which we can use and can build good projects. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

As such I like nothing about sql it's easier to use some time there is connection issue which occurs and it's not an big deal I think. Review collected by and hosted on G2.com.

Jahnavi Y.

Associate consultant

Enterprise (> 1000 emp.)

7/30/2024

"Best tool for using SQL and database management"

4.5/5

What do you like best about SQL Developer?

User friendly interface, shortcuts and options to handle the sql code Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Sometimes take time to open and run the queries. Everything is fine other than that. Review collected by and hosted on G2.com.

Subhadip K.

Senior Consultant

Mid-Market (51-1000 emp.)

12/12/2023

"SQL developer by Oracle is amazing tool for any project"

5/5

What do you like best about SQL Developer?

SQL developer is most powerful and popular tool built by Oracle .There are many editions free to licenced version so that a large number of users can use the same . It manly used for Database integration , and it supports many vendors. We can export data , execute certain plan and fetching table data in our own required formats . We can see the time taken also . For big queries SQL developer is very helpful because it gives hierarchy lines to understand in different colors . Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

There is nothing to dislike and no cons found as such about SQL developer. This amazing tool is good for everyone who want to access database and see table format , space of the cluster. The easy implementation makes easier for any vendor to integrate with it.Oracle itself having very good customer support system for its own products which is good for any company to choose and implement in the project. Review collected by and hosted on G2.com.

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

SQL DEVELOPER solves many a problems in our project. By using this it makes easier to design and development of database system from scratch . It helps to integrate and implement with other applications end point easily.It supports multiple databases , multiple schemas. Import and export of connection is possible here .It supports LDAP,Kerberos , external authentication.One important feature is debugging of PL/SQL code , generates editable PL/SQL blocks . Review collected by and hosted on G2.com.

Raghav G.

Software Developer

Enterprise (> 1000 emp.)

12/14/2023

"SQL Developer: Best way to work with data"

5/5

What do you like best about SQL Developer?

SQL developer is so easy to use and at the same time have all the functionalities you need to work with databases like setting up database connection, user security and especially the workbook so easy and efficient lets you write your query and also suggest auto completion. You can select what you want to run and see result at the same time. All I can say is if you want to work with SQL this is the tool you should use. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Sometime setting up the connection can be a bit of a task and the complex big queries takes some to run and show result. Review collected by and hosted on G2.com.

David C.

Business Intelligence Manager

Enterprise (> 1000 emp.)

1/21/2016

"Drastic improvements over newer iterations, has become a better tool than TOAD"

4.5/5

What do you like best about SQL Developer?

It has many options, easy to us UI. The tab system is done well and there are many DBA functions that can be used through the tool like checking tablespaces, currently running jobs and running execution plans for queries.

There is a DBA window that you can attach a connection to and if you have full DBA rights, then you can perform your functions via a UI instead of having to type them in a command prompt Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It uses a lot of resources and it can sometimes just crash. When I try to remote into my work computer from home, sometimes the SQL Developer just closes itself. It gives no warning. Never had that issue using Toad.

I also havent been able to locate the table locks and which sessions are causing those locks at the moment. I hope to be able to find that functionality soon. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

Make sure your computer has a good amount of ram since this is a memory hog. I had issues running it with 4 gb ram, its been very smooth with 16gb ram. Review collected by and hosted on G2.com.

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

I run analytical queries and test how fast queries are running when users complain about a report running slow. Also check for hanging sessions and can use the tool to request the DBAs to kill the job since I dont have any DBA privileges myself. Review collected by and hosted on G2.com.

Muzaffarhusain S.

Sr Software Developer

Small-Business (50 or fewer emp.)

11/12/2023

"A Powerful Tool for Database Management"

5/5

What do you like best about SQL Developer?

SQL Developer simplifies database management, making it easier to create, edit, and maintain database structures. Its efficient SQL query development tools streamline data retrieval and manipulation tasks. SQL Developer offers strong reporting and data visualization capabilities, aiding in data analysis and reporting tasks. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

A potential drawback of SQL Developer is its relatively steep learning curve for beginners Review collected by and hosted on G2.com.

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

SQL Developer solves the complex challenges of database management, streamlining tasks like schema design, query development, and data manipulation. This efficiency not only saves time but also ensures data accuracy, making it easier to maintain and extract valuable insights from databases, ultimately enhancing productivity and decision-making Review collected by and hosted on G2.com.

Yusoof A.

Database Team Lead

Enterprise (> 1000 emp.)

1/28/2024

"User Friendly Interface"

5/5

What do you like best about SQL Developer?

SQL Developer is very easy to install, setup and integrate with existing databases. I use it almost everyday. I really like the play button that is used to execute the procedures and packages without having to write additional blocks of code. There are buttons to clear your query screen and your output screen that are very helpful. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Multiple settings are needed to configure Format option. It would be better if they provided few templates to choose with preview rather than these settings. Review collected by and hosted on G2.com.

Megha K.

Enterprise (> 1000 emp.)

1/16/2024

"Best IDE for SQL and Oracle Databases"

5/5

What do you like best about SQL Developer?

SQL Developer is easy to use, handy tool. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Heavy IDE that takes a lot of memory to start. Review collected by and hosted on G2.com.

Deepak A.

Software Engineer

Mid-Market (51-1000 emp.)

4/26/2024

"The best SQL tool ever"

4.5/5

What do you like best about SQL Developer?

We can connect to many servers at once and work on them simultaneously. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Nothing to dislike, everything is good and works smooth. Review collected by and hosted on G2.com.

Shreya .

Package Specialist

Enterprise (> 1000 emp.)

11/16/2023

"Robust tool with various advantages"

4.5/5

What do you like best about SQL Developer?

User Friendly Interface,SQL Coding and Editing,Database Administration tools & Integration with Oracle products Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It's an intensive resource with a steep learning curve and have limited non-oracle database support Review collected by and hosted on G2.com.

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

Transferring data between different databases, importing/exporting data in various formats, and managing data movement within Oracle databases. Performing administrative tasks such as user management, schema comparison, indexing, backup and recovery, and monitoring database performance. Generating reports and visualizing data using graphical tools within SQL Developer, allowing users to analyze and present data in a more understandable format. Review collected by and hosted on G2.com.