Introducing G2.ai, the future of software buying.Try now

SQL Developer Pros and Cons: Top Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users value the ease of use in SQL Developer, enjoying its user-friendly interface and helpful documentation. (3 mentions)
Users appreciate the efficient handling of database tasks in SQL Developer, enabling quick query writing and debugging. (1 mentions)
Users find the documentation thorough, making it easy to resolve issues and understand error codes effectively. (1 mentions)
Users appreciate the easy-to-use syntax and user interface of SQL Developer for building projects and data manipulation. (1 mentions)
Users appreciate the flexibility of SQL Developer, benefiting from user-friendly shortcuts and options for SQL code handling. (1 mentions)
Users report connection issues with SQL Developer that lead to longer server connection times, impacting overall performance. (2 mentions)
Users experience slow performance with SQL Developer, especially with larger databases, causing delays in opening and running queries. (2 mentions)
Users experience performance issues with SQL Developer, especially when managing large databases, impacting usability. (1 mentions)

Top Pros or Advantages of SQL Developer

1. Ease of Use
Users value the ease of use in SQL Developer, enjoying its user-friendly interface and helpful documentation.
See 3 mentions

See Related User Reviews

Arpit K.
AK

Arpit K.

Mid-Market (51-1000 emp.)

5.0/5

"An amazing data analysis and management tool"

What do you like 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 an

Verified User
U

Verified User

Mid-Market (51-1000 emp.)

5.0/5

"It's great for teaching"

What do you like about SQL Developer?

It's easy to explain to the people and clarify their doubts and also each error code is well documented when it triggers on the basis of which you can

2. Database Management
Users appreciate the efficient handling of database tasks in SQL Developer, enabling quick query writing and debugging.
See 1 mentions

See Related User Reviews

ND

Neeraj D.

Small-Business (50 or fewer emp.)

5.0/5

"Understanding SQL Developer: Easy Data Management"

What do you like about SQL Developer?

The best thing about SQL Developer is its ability to efficiently handle database tasks. I can write, test, and debug SQL queries quickly, which helps

3. Documentation
Users find the documentation thorough, making it easy to resolve issues and understand error codes effectively.
See 1 mentions

See Related User Reviews

Verified User
U

Verified User

Mid-Market (51-1000 emp.)

5.0/5

"It's great for teaching"

What do you like about SQL Developer?

It's easy to explain to the people and clarify their doubts and also each error code is well documented when it triggers on the basis of which you can

4. Features
Users appreciate the easy-to-use syntax and user interface of SQL Developer for building projects and data manipulation.
See 1 mentions

See Related User Reviews

Arpit K.
AK

Arpit K.

Mid-Market (51-1000 emp.)

5.0/5

"An amazing data analysis and management tool"

What do you like 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 an

5. Flexibility
Users appreciate the flexibility of SQL Developer, benefiting from user-friendly shortcuts and options for SQL code handling.
See 1 mentions

See Related User Reviews

JY

Jahnavi Y.

Enterprise (> 1000 emp.)

4.5/5

"Best tool for using SQL and database management"

What do you like about SQL Developer?

User friendly interface, shortcuts and options to handle the sql code

Top Cons or Disadvantages of SQL Developer

1. Connection Issues
Users report connection issues with SQL Developer that lead to longer server connection times, impacting overall performance.
See 2 mentions

See Related User Reviews

Verified User
U

Verified User

Mid-Market (51-1000 emp.)

5.0/5

"It's great for teaching"

What do you dislike about SQL Developer?

I think it takes too long to connect to their server due to which tho the query execution time is low

Arpit K.
AK

Arpit K.

Mid-Market (51-1000 emp.)

5.0/5

"An amazing data analysis and management tool"

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.

2. Slow Performance
Users experience slow performance with SQL Developer, especially with larger databases, causing delays in opening and running queries.
See 2 mentions

See Related User Reviews

JY

Jahnavi Y.

Enterprise (> 1000 emp.)

4.5/5

"Best tool for using SQL and database management"

What do you dislike about SQL Developer?

Sometimes take time to open and run the queries. Everything is fine other than that.

ND

Neeraj D.

Small-Business (50 or fewer emp.)

5.0/5

"Understanding SQL Developer: Easy Data Management"

What do you dislike about SQL Developer?

It can be slow with big databases and may feel a little heavy on the system at times.

3. Limitations
Users experience performance issues with SQL Developer, especially when managing large databases, impacting usability.
See 1 mentions

See Related User Reviews

ND

Neeraj D.

Small-Business (50 or fewer emp.)

5.0/5

"Understanding SQL Developer: Easy Data Management"

What do you dislike about SQL Developer?

It can be slow with big databases and may feel a little heavy on the system at times.

SQL Developer Reviews (256)

View 1 Video Reviews
Reviews

SQL Developer Reviews (256)

View 1 Video Reviews
4.3
256 reviews
Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
Verified User in Information Technology and Services
AI
Enterprise (> 1000 emp.)
"Intuitive and All-in-One, But UI Feels Outdated and Sometimes Slow"
What do you like best about SQL Developer?

It iIt can feel slow or laggy at times, especially with large queries or connections.

Some features are a bit outdated compared to modern database tools, making the UI feel less polished.s intuitive and easy to navigate, so even complex tasks feel simple.

I also love how it integrates everything queries, tuning, and DB management in one place. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It can feel slow or laggy at times, especially with large queries or connections.

Some features are a bit outdated compared to modern database tools, making the UI feel less polished. Review collected by and hosted on G2.com.

ND
Application Developer
Small-Business (50 or fewer emp.)
"Understanding SQL Developer: Easy Data Management"
What do you like best about SQL Developer?

The best thing about SQL Developer is its ability to efficiently handle database tasks. I can write, test, and debug SQL queries quickly, which helps me save time and avoid errors Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It can be slow with big databases and may feel a little heavy on the system at times. Review collected by and hosted on G2.com.

Verified User in Higher Education
UH
Mid-Market (51-1000 emp.)
"It's great for teaching"
What do you like best about SQL Developer?

It's easy to explain to the people and clarify their doubts and also each error code is well documented when it triggers on the basis of which you can rectify your issue and also you have your tutorials which has great explanation Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

I think it takes too long to connect to their server due to which tho the query execution time is low Review collected by and hosted on G2.com.

Arpit K.
AK
Associate Data Engineer
Mid-Market (51-1000 emp.)
"An amazing data analysis and management tool"
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.

JY
Associate consultant
Enterprise (> 1000 emp.)
"Best tool for using SQL and database management"
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.
SK
Senior Consultant
Mid-Market (51-1000 emp.)
"SQL developer by Oracle is amazing tool for any project"
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.

Raghav G.
RG
Software Developer
Enterprise (> 1000 emp.)
"SQL Developer: Best way to work with data"
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.
DC
Business Intelligence Manager
Enterprise (> 1000 emp.)
"Drastic improvements over newer iterations, has become a better tool than TOAD"
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.

Muzaffarhusain S.
MS
Sr Software Developer
Small-Business (50 or fewer emp.)
"A Powerful Tool for Database Management"
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.

Yusoof A.
YA
Database Team Lead
Enterprise (> 1000 emp.)
"User Friendly Interface"
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.

Product Avatar Image
SQL Developer
View Alternatives