# SQL Developer Reviews **Vendor:** Oracle **Category:** [Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms) **Average Rating:** 4.3/5.0 **Total Reviews:** 259 ## About SQL Developer 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. ## SQL Developer Pros & Cons **What users like:** - Users value the **efficiency in handling database tasks** with SQL Developer, simplifying complex operations and enhancing productivity. (3 reviews) - Users find SQL Developer to be **intuitive and easy to navigate** , simplifying complex tasks and enhancing usability. (2 reviews) - Users value the **powerful analytics capabilities** of SQL Developer for analyzing large transaction data and detecting risks. (1 reviews) - Users benefit from the **big data handling capabilities** of SQL Developer, enabling effective analysis and insightful reporting. (1 reviews) - Users find the **well-documented tutorials and error codes** helpful for clarifying doubts and troubleshooting effectively. (1 reviews) - Users appreciate the **easy integrations** in SQL Developer, finding it simplifies complex database management tasks. (1 reviews) - Learning (1 reviews) - Navigation Ease (1 reviews) - Speed (1 reviews) - Time Saving (1 reviews) **What users dislike:** - Users find SQL Developer's performance can be **slow and laggy** , particularly with large queries and databases. (2 reviews) - Users often face **connection issues** , resulting in delayed server access despite quick query execution times. (1 reviews) - Users find **difficult learning** due to awkward debugging of SQL queries and limitations in advanced features and portability. (1 reviews) - Users find **function limitations** in SQL Developer, particularly in debugging, portability, and advanced feature engineering. (1 reviews) - Users experience **slowness with large databases** , often finding SQL Developer heavy on system resources. (1 reviews) - Users find the **poor interface design** of SQL Developer to be laggy and less polished than modern tools. (1 reviews) - Small Business Limitations (1 reviews) ## SQL Developer Reviews ### 1. SQL Developer is a great tool for connecting to multiple DBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Antoine S. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** June 06, 2023 **What do you like best about SQL Developer?** I like the way SQL Developer connects to multiple DBMS using the same interface. **What do you dislike about SQL Developer?** I cannot think of anything I dislike about SQL Developer at this time. **What problems is SQL Developer solving and how is that benefiting you?** SQL Developer helps me manage my databases in a clean and concise fashion, ### 2. Oracle SQL Developer Tool Review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** November 01, 2023 **What do you like best about SQL Developer?** It's processing, UI and views and shortcut including features. **What do you dislike about SQL Developer?** Sometime slowness and crashing app frustrate as SDE. **What problems is SQL Developer solving and how is that benefiting you?** It's managing the DB very efficiently and effectively and thus enhancing the user experience. ### 3. Oracle SQL Developer : A place where you can create and manage your databases easily! **Rating:** 4.5/5.0 stars **Reviewed by:** Swagata Laxmi B. | Intern, Enterprise (> 1000 emp.) **Reviewed Date:** September 10, 2022 **What do you like best about SQL Developer?** Things that I like the most about Oracle SQL Developer: -Using this, we can create and maintain numerous databases and tables with just a few steps. -The User Interface is straightforward; therefore, It will take no time to learn. -It comes with some default tables, which will be helpful for beginners as a quick start to execute queries. -You can connect to other applications/software easily and quickly. -And, of course, It's free to use. **What do you dislike about SQL Developer?** -The configurations you need to do might seem overwhelming initially, but it will get easier with time. -Sometimes, the app freezes on my laptop. -Autosave is unavailable, so you have to save your queries manually(Don't worry, the tables will be there even if you don't save them). **What problems is SQL Developer solving and how is that benefiting you?** - As a Data Integration intern, I have used SQL Developer by connecting it with various ETL tools for data integration, such as Informatica Powercenter, Talend, IICs etc., and they work smoothly without delay, i.e., the tables are updated immediately. ### 4. Amazing Experience! **Rating:** 5.0/5.0 stars **Reviewed by:** Aman A. | System Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 03, 2023 **What do you like best about SQL Developer?** It's amazing. It solve your tideous task into simpler one. Easy to integrate and manage. **What do you dislike about SQL Developer?** No dislikes founds yet. It's amazing to write your SQL query. **What problems is SQL Developer solving and how is that benefiting you?** It's solve your complex work within minutes. You can write your any complex query. ### 5. Outsystems - Must Try By SQL Developer **Rating:** 4.5/5.0 stars **Reviewed by:** Siddharth V. | Small-Business (50 or fewer emp.) **Reviewed Date:** March 30, 2023 **What do you like best about SQL Developer?** It takes Less time to Manipulation of Data. Simple Interface of Data **What do you dislike about SQL Developer?** It is very difficult to remember too many queries and commands **What problems is SQL Developer solving and how is that benefiting you?** Organized data in a tabular form just like an excel sheet Less changes Save time for execution ### 6. SQL Developer - Easy to use and execute data objects **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** October 19, 2022 **What do you like best about SQL Developer?** 1. SQLDeveloper is a user-friendly tool for writing and executing queries. 2. Monitoring of sessions and executed SQLs becomes easy. 3. Create and Maintain connections. 4. Access all Database objects which are in the grant. **What do you dislike about SQL Developer?** Sometimes, the heavy load on the system and database when executing big data objects like procedures makes it get into hang mode, making it difficult for the user to debug/analyze the execution process after forcefully closing it. **What problems is SQL Developer solving and how is that benefiting you?** 1. ER diagram view/design. 2. Worksheet with suggestions to execute the queries easily. 3. Import/export data,connections. 4. Data Model design view, export 5. It comes with an in-built query builder and SQL history maintenance option. ### 7. SQL Developer Tool Review **Rating:** 4.5/5.0 stars **Reviewed by:** Muralidharan A. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 23, 2022 **What do you like best about SQL Developer?** SQL Developer is very flexible tool for accessing the data, and to manipulate the data. **What do you dislike about SQL Developer?** UI needs to be improved, so that it looks more attractive. **What problems is SQL Developer solving and how is that benefiting you?** Awhile running multiple query there is chance of runnt the wrong query. Because of improper space or indentation maintenance. ### 8. Efficient tool to debug PLSQL packages **Rating:** 4.5/5.0 stars **Reviewed by:** Shehan D. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** May 22, 2022 **What do you like best about SQL Developer?** It's easy to debug the packages written by Plsql code, and also it allows to control of the oracle database in configurations + monitoring using $ tables. **What do you dislike about SQL Developer?** Eventually, the debugger might hang while debugging the packages if the package has thousands of lines. However, it can be done using the debug points rather than going through the line by line in the code. **What problems is SQL Developer solving and how is that benefiting you?** Investigate the ORA errors in the PLSQL packages, evaluate the code performance, gather statistics, create and modify the table indexes, and add autonomous traces to the packages to track the data flow. ### 9. Easy to create and manipulate SQL objects **Rating:** 4.5/5.0 stars **Reviewed by:** Sharan D. | Quality Assurance Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** May 22, 2022 **What do you like best about SQL Developer?** Easy to monitor the performance of PLSQL codes and analysis the time and get the profiler report to understand which code part takes much time to complete. And it will allow checking the explain plan for the specific SQL query. **What do you dislike about SQL Developer?** when I ran the profiler report for a test code the application went 'Not Responding’ most of the times. However, it returns to live once the report completed. **What problems is SQL Developer solving and how is that benefiting you?** Performance monitoring in oracle databases, check to explain plan for SQL queries whether to identify it run through the valid indexes. ### 10. Oracle SQL Developer - Best tool for oracle data manipulation work. **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** May 22, 2022 **What do you like best about SQL Developer?** As my primary skill was Oracle SQL, PLSQL, I mainly used SQL developer for Oracle data retrieval, insertion, and updation work. Now-a days just data retrieval is not useful, so performance tuning is playing a key role in any company and this tool has an inbuilt feature of explain plan which I mostly used for query tuning. **What do you dislike about SQL Developer?** The downside of SQL developer is that when you export data into any file with a million rows, it takes longer to export and sometimes hangs. Another thing is that if an export operation is going on and you want to cancel that activity, this tool is not that user-friendly. **What problems is SQL Developer solving and how is that benefiting you?** With the help of SQL Developer, we solved data uploading from file to table, export operation, migration, and data correction problems. The benefit we have got from SQL developers is that we have built a lot of MIS reports, tuned a lot of SQL queries, and done PLSQL coding to solve complex business requirements. ### 11. Worthy Tool For Handling Database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 27, 2022 **What do you like best about SQL Developer?** 1. Fetching and extracting of data is very easy. 2. User interface is also very good 3. It comes at very cheap price as compared to other product present in market **What do you dislike about SQL Developer?** 1. Sometimes managing large data become hectic 2. Proper documentation for accessing the features over internet is limited 3. Sometimes not able to get solution for ORA errors happening for statement **What problems is SQL Developer solving and how is that benefiting you?** My company is maintaining whole data in very efficient manner for our clients at very good price ### 12. Fetch, Analyzed large scale data with SQL Developer **Rating:** 5.0/5.0 stars **Reviewed by:** YOGENDRA G. | Assistant Manager, Enterprise (> 1000 emp.) **Reviewed Date:** March 30, 2022 **What do you like best about SQL Developer?** This tool is best to perform the database operations like DDL , DML, DCL on oracle database. I saw the performance is very good and it's an user friendly tool which always gives satisfaction to users. Making connect is very easy and using this tool for data analysis is always gives quick insights out of the data. **What do you dislike about SQL Developer?** It sometimes hang if we handled large anount of data or any complex sql procedures. Interface of this tool is good but can be improved further. Queries inspection could be better like toad so that user can do deep data analysis using this took. **What problems is SQL Developer solving and how is that benefiting you?** I used this tool for frequently in my start of career, there was a project where we need to go deep dive into data, energy consumption on daily and weekly basis etc and it outperformed there. ### 13. SQL Developer- The Heart of Oracle **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** August 07, 2022 **What do you like best about SQL Developer?** * It helps us to manage the database efficiently * Easy to access and auto suggestions are good * We can get all previously used scripts and we can manage large data **What do you dislike about SQL Developer?** * Sometimes Hanging if not used more than 5 mins * Date columns are not prompting time by default *Sometimes it uses more RAM than expected **What problems is SQL Developer solving and how is that benefiting you?** * Able to manage client Support activities( Development/ issue fix/bug identification) ### 14. Best IDE to talk with Oracle Databases **Rating:** 4.0/5.0 stars **Reviewed by:** Ronit N. | Senior Application Developer, Enterprise (> 1000 emp.) **Reviewed Date:** December 02, 2021 **What do you like best about SQL Developer?** To summarize, the most likable features of Oracle SQL Developer : 1. Clear, crisp, and concise UI. Minimalist UI makes SQL developer a beginner's friendly IDE for SQL and PL/SQL developers. 2. Connection manager enables the user to manage, create and delete database connections. 3. The connections are portable in XML or JSON format. And to export and share the database connections, we need not share the connection password, and we can encrypt the connection files with an encryption password. 4. Multi-tab query feature. In a SQL developer, we can open multiple tabs (SQL worksheets), we can develop multiple queries at the same time. 5. Supports Oracle NoSQL connections. 6. Easy to debug code with the "Message Log" feature. 7. Open source and available for free. Just one needs to create a free oracle account, all of which is free of any cost, and no Credit card is required. 8. Best IDE to write PL/SQL code blocks, although Oracle has a PL/SQL developer, developers prefer SQL developer to write / developer / manage PLSQL code blocks (Package/Procedure/Functions). **What do you dislike about SQL Developer?** There are a few points, which I would like Oracle to improve about the SQL developer, those are : 1. The Software is resource-intensive. I have seen machines with less than 4 GB of Ram struggle to run this software. 2. There is a limitation in the view of the result set. When a user drags down to scroll through the entire result set, it freezes after 20-30 rows of the result set. 3. If a connection is left unused for more than 10 minutes, the connection drops, and it resets, the transaction session is dropped. 4. With VPNs, SQL developer frequently drops the connection. **What problems is SQL Developer solving and how is that benefiting you?** With the Oracle SQL Developer, we write SQL codes to generate reports about financial transactions. In SQL Developer, we run scripts that update data in the database, and we commit the changes with SQL Developer. To create automated database solutions, we write PLSQL blocks of code /update and maintain them in SQL Developer. Additionally, it's elementary and user-friendly, so we give introductory SQL lessons to new beginners in the SQL Developer IDE. ### 15. Efficient tool for DBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** August 01, 2022 **What do you like best about SQL Developer?** It is easy to retrieve and data extraction from SQL. Customization and Manipulation can be done without any interruption. Accessible and user-friendly interface **What do you dislike about SQL Developer?** The constraint of language standardization restricts user functionality. The processing speed seems quite low. **What problems is SQL Developer solving and how is that benefiting you?** It helps to query processing without coding skills. Able to run complex queries for data extractions. User-friendly interface with a lot of tool customization. ### 16. Review of Sql developer **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 25, 2022 **What do you like best about SQL Developer?** Sql developer has the ability to browse across the datsbase components and easily modify or drop them or even create new ones. Debugging is also easy incase of issues. **What do you dislike about SQL Developer?** The stability is less when the query takes a long time to execute. When ussge is heavy then it lags a lot. Reconnect takes a long time when the database has been disconnected unexpectedly. **What problems is SQL Developer solving and how is that benefiting you?** UI of Sql developer is easily accessible. It has the ability to connect with multiple schemas simultaneously. Debugging is easy when we have issues. We can export the result set into our desired format. ### 17. Best client tool for Oracle Database for Beginners **Rating:** 3.5/5.0 stars **Reviewed by:** Muhammad U. | Database Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 24, 2021 **What do you like best about SQL Developer?** Well SQL Developer is good for beginners. They can easily run/ test queries with the simpler editor. Also, they can add, delete, and search, update manually from the schema browser window. It provides some handy features like Data Modeling. We just need to drag and drop our tables into windows it will automatically draw relations between tables. It also provides Export/ Import utilities. We can also connect as a DBA in the DBA window. **What do you dislike about SQL Developer?** The bad thing about SQL Developer is that it got disconnect after every 10 minutes if we don't use it. Which is very irritating. It does not have the searching facility for a specific object like Sequences, Triggers, Tables etc. I will not recommend this software for professional or senior developers. **What problems is SQL Developer solving and how is that benefiting you?** Database Development, ER Modeling, Data Management, Import and Exports of Flat files and Databases, Learned basics of the database, DBA tasks ### 18. My review for Oracle SQL Developer **Rating:** 4.0/5.0 stars **Reviewed by:** Naqash H. | Software Quality Assurance Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 21, 2021 **What do you like best about SQL Developer?** Its user interface is simple and convenient to learn and understand for a new user. Especially the drag-and-drop feature for the tables and relations makes things very convenient. **What do you dislike about SQL Developer?** Its frequent disconnection is problematic for me. If there is no activity for a certain time, the SQL Developer disconnects. It also takes a good amount of time to load. **What problems is SQL Developer solving and how is that benefiting you?** SQL Developer makes it easy to debug as it displays a clear error message if it encounters one. As a beginner, it was easy for me to learn to use it and handle the Oracle database. ### 19. Great tool for Oracle DB Management **Rating:** 4.5/5.0 stars **Reviewed by:** Mohan Rajesh K. | Lead Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 28, 2021 **What do you like best about SQL Developer?** It helps in connecting to remote databases as well with ease. We can do all DB operations with ease and perfection. I have used it to connect to my Oracle Databases which are at remote locations **What do you dislike about SQL Developer?** The load time of the SQL Developer is too long which can be improved a lot to make it the best in the market **What problems is SQL Developer solving and how is that benefiting you?** We used to work on complex SQL queries, procedures, functions, and triggers, etc... It also allows me to save the back up and restore the databases which is exceptional feature ### 20. Best IDE for Database work **Rating:** 4.5/5.0 stars **Reviewed by:** Krishna M. | Android and Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 17, 2022 **What do you like best about SQL Developer?** We can exported data in various file format simply. Best performance. Database components easily modify/dropped. Multiple database can connect easily **What do you dislike about SQL Developer?** Automatically disconnected when network slow. **Recommendations to others considering SQL Developer:** Fetching data ,customizes data and easy to install this **What problems is SQL Developer solving and how is that benefiting you?** When I connected two database some problem are faces, they are not connected. Then i read documentation and connect easily. ### 21. SQL Developer Overview **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 08, 2022 **What do you like best about SQL Developer?** Easy user interface is probably makes it one of the best available tool in market, specially for beginners also it's very easy to learn and write code in SQL developer. **What do you dislike about SQL Developer?** Sometimes it disconnected automatically while the connection is slow. Also faced issues while extracting a large data, suppose if connection drops while extracting a large amount of data then we need to take the extract again from starting. **What problems is SQL Developer solving and how is that benefiting you?** We are developing all business solutions using SQL Developer only in my current project. Sometimes we also require to send the extract as per client requirement . ### 22. Oracle SQL Developer Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** December 21, 2021 **What do you like best about SQL Developer?** Build and analyze SQL queries by connecting multiple databases from one tool. Import data easily from text files, Excel files, and CSV files..etc Easy to install and configure. User-friendly GUI and easy to navigate through various features easily. **What do you dislike about SQL Developer?** It uses a lot of desktop/laptop memory. Lack of scheduling jobs and needs to improve Export or import data from on-prem to cloud easily Nice to have a drag and drop feature. **What problems is SQL Developer solving and how is that benefiting you?** Day-to-day activities by connecting multiple databases at the same time. Users who don't have much knowledge can navigate easily using the tool for development The tool meets all basic needs. ### 23. Review of SQL Developer **Rating:** 4.5/5.0 stars **Reviewed by:** PRASHANTH V. | Senior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 15, 2021 **What do you like best about SQL Developer?** It is a graphical version of sql plus ,it is easy to connect different databases and different schemas ,easy to connect MySQL and other databases using the relevant drivers. Easy to see the result set and also to export as a file. **What do you dislike about SQL Developer?** It is taking more time in first time setup as we need to give correct path of java installed in your system. Sometimes it's taking more time to open the application itself. **What problems is SQL Developer solving and how is that benefiting you?** Easy to query with this Gui and inbuilt suggestions to query with different schemas and databases. It is very effective to take reports from this tool. ### 24. Review for the Oracle SQL Developer **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** February 20, 2022 **What do you like best about SQL Developer?** Oracle SQL Developer is the best choice of product to write the SQL code and to connect with multiple databases. This can work across various environments. Switching between the environments is easy. **What do you dislike about SQL Developer?** The constraints in the table should be managed in a better way. There are some constant unexpected crashes which are not well explained. Sometimes db gets disconnected and the reconnection to the db is not working properly. **What problems is SQL Developer solving and how is that benefiting you?** Creating a partition on the table is pretty easy when compared to other databases. Fetching the data and exporting the data in any format is also simple. Debugging of queries is smooth. ### 25. Review for Oracle SQL Developer **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** December 31, 2021 **What do you like best about SQL Developer?** The Oracle sql developer is very user friendly and in this we can also protect our database by setting up a password to it, without entering the correct password we cannot run our queries. So that our data is secure. **What do you dislike about SQL Developer?** Eventhough when we save the files and when we close the app and the next day we open the file is not there in sql developer and we have to open it again. It should have the feature to save the file in the app itself. **What problems is SQL Developer solving and how is that benefiting you?** We can able to manage the settings like what kind of queries should be deployed in our db and what queries should not be deployed. This helps in data security and helps us to save our data from wrong queries. ### 26. Sql Developer with oracle db 12c **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Insurance | Small-Business (50 or fewer emp.) **Reviewed Date:** April 12, 2022 **What do you like best about SQL Developer?** its so straightforward and easy to use you can connect multiple db to the sql developer and its free **What do you dislike about SQL Developer?** i dislike the abolity to backup the database **What problems is SQL Developer solving and how is that benefiting you?** i can access al my company data and create reports ### 27. All about SQL developer **Rating:** 4.5/5.0 stars **Reviewed by:** SHUBHAM G. | Technology Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** April 04, 2022 **What do you like best about SQL Developer?** An easy user interface, no installation required. The new connection setup is very smooth. **What do you dislike about SQL Developer?** Query auto-completion feature is not available. **What problems is SQL Developer solving and how is that benefiting you?** It helps to analyze our business in a much more organized and better way. ### 28. My New Go To SQL Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Broadcast Media | Enterprise (> 1000 emp.) **Reviewed Date:** December 14, 2021 **What do you like best about SQL Developer?** The big difference is how the handle variables, stored procedures, and built-in functions. Oracler SQL can group procedures into packages. MS SQL Server. cannot do tho " While PL/SQL is more complex and has more' capabilities,' T-SQL is simpler and easier to use. **What do you dislike about SQL Developer?** Run time errors are frustrating; Constraints on the table could be managed in a better way; There is virtually no instruction manual, so it can take time to figure out the features Uses more RAM than other Microsoft option and crashes more often when running scripts **What problems is SQL Developer solving and how is that benefiting you?** Easy to use; Integrates with Oracle DB well; Easy for beginners; Quick to access; Debugging is easy. and Oracle SQL Developer displays what ever the error is. ### 29. SQL Developer helps to deal with large amounts of data in form of tables. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** January 17, 2022 **What do you like best about SQL Developer?** SQL Developer helps create tables and stored procedures while also manipulating data using Data manipulation language and commands like delete, insert, and update. **What do you dislike about SQL Developer?** SQL Developer is now becoming a legacy software. Most of the leading companies are adapting to POSTGRES. Oracle needs to develop updated features than stick to the fundamentals of Database operations. **What problems is SQL Developer solving and how is that benefiting you?** SQL Developer by Oracle is an easy-to-learn software for beginners to deal with data and queries. SQL Developer helps create tables and stored procedures while manipulating data using Data manipulation language and commands like delete, insert and update. ### 30. I am a database developer and using sql developer to develope my databases. **Rating:** 4.5/5.0 stars **Reviewed by:** osama k. | Dotnet Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** January 19, 2022 **What do you like best about SQL Developer?** it's easy to use. It's portable no installation. lastly easy to handle with multiple instances. **What do you dislike about SQL Developer?** Sometimes instance expires automatically. **What problems is SQL Developer solving and how is that benefiting you?** I used SQL developer to develop the database, query from the databases. if the developer need store procedures I have to create it using SQL developer. ### 31. Review of SQL Developer **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** January 10, 2022 **What do you like best about SQL Developer?** The ease of use is the best part of SQL Developer. I haven't enjoyed this ease with other databases like MS SQL Server. E.g., the rollback feature is such a blessing! **What do you dislike about SQL Developer?** I can barely think of anything! Right now, I miss working with SQL Developer. **What problems is SQL Developer solving and how is that benefiting you?** Whenever I make any code change, I quickly go to SQL Developer to verify if the data is absorbed or transformed correctly. I also use it to display 'explain plans' to make the SQLs better. ### 32. Oracle SQL Developer is an amazing database application. **Rating:** 5.0/5.0 stars **Reviewed by:** Sushma K. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** May 02, 2021 **What do you like best about SQL Developer?** Oracle is the largest company in relational databases and the tool of choice for operation, high-performance database workflows. We can be confident which specific efficiency and functionality requirements are fulfilled thanks to Oracle RDBMS's reliability, as well as increased & disaster recovery services like Oracle RAC or Data Guard. Oracle SQL Developer provides excellent performance efficiency, consistency, and security. **What do you dislike about SQL Developer?** Oracle SQL Developer has not caused any problems for us. **Recommendations to others considering SQL Developer:** That would be a very robust database management system. One could query large databases quite quickly. I highly suggest the service to every company. **What problems is SQL Developer solving and how is that benefiting you?** For Development/Testing, we have used Oracle SQL Developer Database. In terms of coverage as well as usability, it is pretty simple to use. It is handy, particularly for software engineers. ### 33. 'SQL Developer is easy and quick' **Rating:** 4.5/5.0 stars **Reviewed by:** Sunandan M. | Senior Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** October 06, 2021 **What do you like best about SQL Developer?** SQL Developer is really an easy tool to work upon. The export-import of files is easy and supports all major file formats like Excel, CSV, and XML **What do you dislike about SQL Developer?** Sometimes the connection to the database lags. **What problems is SQL Developer solving and how is that benefiting you?** Our organization is using SQL Developer for a long now and it is really reliable. The interface is user-friendly and there is no need for any training to work on it. Query writing and updating are easy and quick. Overall we have been more than satisfied. ### 34. Best and easy tool for Database management **Rating:** 5.0/5.0 stars **Reviewed by:** Bushra M. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 09, 2021 **What do you like best about SQL Developer?** - Easy to install - User-friendly UI - Can import data from text, Excel, CSV file - Easy debugging of the stored procedures - Easily know table dependencies - Error details and line number on failed execution of the query - Can execute number of queries simultaneously - Shows number of rows affected **What do you dislike about SQL Developer?** Automatically gets disconnected if it is in idle state. **What problems is SQL Developer solving and how is that benefiting you?** Using this software on a daily basis to run queries, write stored procedures, and debug. ### 35. "One of the best tool for database Development" **Rating:** 4.5/5.0 stars **Reviewed by:** Ashutosh G. | Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** September 24, 2020 **What do you like best about SQL Developer?** This is one of the most used tools in our organization we are mainly using it for creating tables and data sources. The user interface is amazing and it's very to understand and navigate. You can easily write a query and spool the data as per your requirement. Creating reports and dashboards are also very convenient and easy with SQL developers. **What do you dislike about SQL Developer?** There are some limitations like you cannot search more than 1000 records at a given time etc. But overall its the great tool. **What problems is SQL Developer solving and how is that benefiting you?** With the help of this tool, we are able to develop various reconciliation between different data sources. We can easily create delete or modify any table as per the requirement. It's very secure and the query output generated is really fast within seconds. ### 36. An essential tool to manage our database **Rating:** 5.0/5.0 stars **Reviewed by:** Rachel S. | Consultant e-learning content, Enterprise (> 1000 emp.) **Reviewed Date:** September 20, 2021 **What do you like best about SQL Developer?** SQL Developer is the easiest and quickest way to see the data in the system. In addition to offering a complete and efficient service, it is free! **What do you dislike about SQL Developer?** The only negative point of SQL is the impossibility of implementing recursive processing. **What problems is SQL Developer solving and how is that benefiting you?** It’s a great tool that has allowed us to standardize a database. We have also improved the processing of our data. We perform data analysis thanks to the queries utilizing a lot of joins. ### 37. It's complete, and it's free! **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Consumer Services | Mid-Market (51-1000 emp.) **Reviewed Date:** March 30, 2021 **What do you like best about SQL Developer?** What a tool like SQL Developer needs to do, it does... I'm used to TOAD and Microsoft SQL Server Management Studio, and SQL Developer in a lot of aspects outperforms these products. It's clean and highly intuitive, no learning curve required whatsoever. **What do you dislike about SQL Developer?** If you really push me to mention something negative, then I have to mention the fact that you can't easily navigate from and within stored procedures or any other object. Within TOAD you can very easily do this through shortcuts. Just write down the name of a stored procedure, and you can right click it, or use a shortcut to immediately go there. In SQL Developer I find myself too often scrolling to the stored procedure. I know... it's only a small discomfort. I'm not a power user (not a dba or stored procedure developer). I use this tool only for querying and looking up (and ORDS design). From what I hear from the "real" power users, they all prefer TOAD for the beforementioned reason. **What problems is SQL Developer solving and how is that benefiting you?** I use the tool to quickly query, to test sql statements in code, to check how and why some API's don't give me the expected result. Also closing blocking sessions in our organization, and sometimes database design. What I need is a fast and intuitive tool, that enables me to quickly solve bugs in any application that has some form of database connection. TOAD for that matter is too complex (and chaotic). SQL Developer is my friend. ### 38. Best DB manager and IDE tool for Oracle database and applications **Rating:** 4.0/5.0 stars **Reviewed by:** Subrata G. | Technical Lead, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** March 21, 2021 **What do you like best about SQL Developer?** SQL Developer, is available on multiple platforms, Windows Mac Linux and Oracle doesn't charges a penny for it. So, SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage and develop Oracle Database in both on premise and Cloud deployments. SQL Developer can also connect and interact with non oracle database like IBM db2,MS Sql server and MySQL etc. Its installation package is available in two formats, one is normal exe and other portable zip compressed file. And it gives session management console, which is lacking in many other competitor's product. **What do you dislike about SQL Developer?** The output window shows very less number of data records at a time, and scrolling with mouse in the output screen, makes the SQL Developer freeze and it starts struggling. SQL Developer at times, consumes too much of memory and RAM. Ideally a machine should have at least 8 Gb of Ram. Connections import and export is bit tricky, older versions supported xml and new versions support json. So updating the SQL Developer may be a bit clumsy if you overlook this fact. **What problems is SQL Developer solving and how is that benefiting you?** We the Oracle application developers team use SQL Developer to develop, PL/SQL code for our customer. PL/SQL developer is bit clumsy, while SQL Developer is very clean and hassle free to maintain and develop PL SQL codes. The database administrators and cloud admins use this SQL Developer console to manage connections and database users to the environment. Training new joiners is also done in SQL Developer. ### 39. SQL Developer Review **Rating:** 5.0/5.0 stars **Reviewed by:** Vineeth V. | Assistant Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** August 11, 2021 **What do you like best about SQL Developer?** User Friendly, Easy to write complex queries, fast search, and retrieval of results **What do you dislike about SQL Developer?** Extracting the retrieved data to an excel or CSV takes a long time. If you have any project that needs to pull a lot of data in excel, this tool is not advisable. **What problems is SQL Developer solving and how is that benefiting you?** I perform data analysis by filtering the search results of queries utilizing a lot of joins. It has mainly benefited by providing significant time savings. ### 40. Oracle Sql Developer Tool Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** March 03, 2021 **What do you like best about SQL Developer?** 1. Lightweight Application, doesn't take much time to start. 2. Many people think that oracle SQL Developer GUI is a bit old, but I personally feel that its easy to understand and work with. 3. SQL Developer tool automatically recognizes the syntax tags and highlights them in different color which provides good understandable representative look. As well as it always prompts the syntax/table/column names while typing any query. 4. As it's easy to know how many rows and tables will be affected after performing certain operations on database, it makes a good tool for both development and testing purpose. 5. By the help of this tool, you can import or export the data very easily. **What do you dislike about SQL Developer?** 1.Oracle SQLDeveloper Tool doesn't automatically resets connection. If you've half done your work today and tomorrow you want to continue the same then you have to again choose the connection or continuously refresh it else it'll give error message. 2. If you don't know the status of query and if query is taking too much time to respond, it shows the status as RUNNING whereas in reality the query may have hung up. It should provide clear message of query status whether it's running or stuck in between. And this happens many times with me. 3. You can't simultaneously run multiple queries of a single database connection. You have to wait for successful execution of first query, then only it'll move ahead to execute next query in the line. 4. Instead of showing only the error at line, more simplified message should be provided to address the error. **What problems is SQL Developer solving and how is that benefiting you?** 1. By just clicking on the table name, you can know all the information about table such as dependencies, triggers, constraints. 2. You can provide comments/ instructions to show what certain column values will mean. 3. By clicking on minimize button on the left hand side at the start of the query, you can provide better understanding view and give more space to output section. ### 41. A very good tool with so many featured. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Enterprise (> 1000 emp.) **Reviewed Date:** December 16, 2021 **What do you like best about SQL Developer?** The tool has so many things to offer and easy to use **What do you dislike about SQL Developer?** It's user interface can be improved. It still looks like it was built in the 1990s **What problems is SQL Developer solving and how is that benefiting you?** Datawarehousing solutions. Easy to use ### 42. Best data modeling tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** November 23, 2021 **What do you like best about SQL Developer?** IntelliSense, highlight errors, provide autosuggestions **What do you dislike about SQL Developer?** It does not notify that the WHERE clause is missing in the UPDATE command. **Recommendations to others considering SQL Developer:** It's the best tool for data modeling. **What problems is SQL Developer solving and how is that benefiting you?** Data Processing, Data Retrieving, Data Usage ### 43. Ease of use for SQL **Rating:** 4.0/5.0 stars **Reviewed by:** Alisson S. | Trainee, Mid-Market (51-1000 emp.) **Reviewed Date:** November 19, 2020 **What do you like best about SQL Developer?** I like the layout of the application, buttons, menus on my first use it was not difficult to find me. The shortcuts I use a lot, have a lot of customization tools and have added a lot to me. **What do you dislike about SQL Developer?** I had a problem with a table with Clob of the system (passes up to 8 thousand characters) sometimes in the select it hangs even bringing less data. I even did a test that ran only the developer and passed, so I believe it is something from my memory, but I could have some feedback from this freeze. I already did a test and left the application open and 1 hour went by without response. **What problems is SQL Developer solving and how is that benefiting you?** Anything that is a business problem, because I use this tool as my main tool. ### 44. User Experience of Sql Development Tools **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Hardware | Mid-Market (51-1000 emp.) **Reviewed Date:** April 24, 2021 **What do you like best about SQL Developer?** The best part of this is that you can write complex queries and fetch data according to your needs. Stored a large amount of data according to your industrial needs. **What do you dislike about SQL Developer?** The only problem that I have seen in this there performance. When there is vast amount of data stored table, then the performance of fetching data decreases. **Recommendations to others considering SQL Developer:** Please try at least once if you have a huge Volume of data and you want to manage it in tabular form. **What problems is SQL Developer solving and how is that benefiting you?** Our enterprise application use SQL server to store our data. so we as a sql developer works to write complex queries to get data from there as per the business requirments. Also it provide the feature of reportings. so we don't have to depend on other BI tools ### 45. SQL Developer - My best IDE friend **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Oil & Energy | Enterprise (> 1000 emp.) **Reviewed Date:** March 18, 2021 **What do you like best about SQL Developer?** It is very simple to use and intuitive. It also has a clear structure, so anyone who works in SQL Developer has a complete picture of the database objects. One of the best parts of SQL Developers is snippets. It is a very practical way to have parts of the code at hand. **What do you dislike about SQL Developer?** There is no multi-filter function (creating multiple filters and applying when you want). **Recommendations to others considering SQL Developer:** If you want to be agile when developing solutions in PL/SQL, SQL Developer is your best friend! **What problems is SQL Developer solving and how is that benefiting you?** I am developing DB schemas, creating DDLs and DMLs, testing procedures and functions, creating reports, etc. ### 46. Excellent **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 02, 2021 **What do you like best about SQL Developer?** Ease of use. It's excellent software. Very easy to use and can customize as we want. **What do you dislike about SQL Developer?** Sometimes glitches. It can get stuck, and then you have to restart. **What problems is SQL Developer solving and how is that benefiting you?** I use it daily for my office. I need to run many queries day-to-day basis and this is my fav software. ### 47. Oracle Database Viewer ,SQL editor, Query debugging **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** September 02, 2021 **What do you like best about SQL Developer?** Capability to debug the queries ,stored procedures Easily,Tools for Writing the queries like highlighting the Queries syntax and auto format of code . **What do you dislike about SQL Developer?** This product does not have any particular dislikes **What problems is SQL Developer solving and how is that benefiting you?** I am using this application to write oracle SQL Queries ### 48. Review- sql developer **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** August 24, 2021 **What do you like best about SQL Developer?** As a developer this was the best tool for building custom applications **What do you dislike about SQL Developer?** Version changes and integration was little tricky **Recommendations to others considering SQL Developer:** I will highly recommend this tool for all size companies **What problems is SQL Developer solving and how is that benefiting you?** Build custom application for management decisions ### 49. Oracle SQL Developer Review **Rating:** 5.0/5.0 stars **Reviewed by:** Ankur S. | Associate System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 26, 2020 **What do you like best about SQL Developer?** The best thing i like about Oracle SQL Developer is its user interface . It has easy to use platform including its navigation to different features , connectivity to different local environments . Also , different schemas can e handles with ease . Also , the installation process is pretty simple . **What do you dislike about SQL Developer?** I have not found any cons as of now . It gets me all the basic work done. The only point can be its heaviness as it consumes more RAM . **Recommendations to others considering SQL Developer:** Its a easy to use platform providing all the features that one expect . **What problems is SQL Developer solving and how is that benefiting you?** I am using Oracle SQL developer in verifying GUI data with the database . Also using oracle SQL developer with selenium automation like fetching otp from the database , modifying data from backend etc . ### 50. SQL Developer - Oracle DB IDE **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 16, 2021 **What do you like best about SQL Developer?** Oracle is the widely used database as SQL Developer is a nice IDE in many ways which includes : - It makes very easy to explore the database objects definitions eg: Tables, Views, Packages etc. - It makes very easy to export data on files. - Convenient to debug PL/SQL procedures. **What do you dislike about SQL Developer?** As soon as a running query is cancelled before finishing, it resets the DB connection sockets which hangs the tool for a few seconds. **Recommendations to others considering SQL Developer:** One of the top tool to make your life easy if Oracle DB is part of your tech stack. Comes handy in all the stages be it development, deployment or support. **What problems is SQL Developer solving and how is that benefiting you?** - To explore data using the query engine. - To make DDL queries. ## SQL Developer Discussions - [Do you plan to develop multi-filter features (ie creating multiple filters, and using them when it is needed)?](https://www.g2.com/discussions/47152-do-you-plan-to-develop-multi-filter-features-ie-creating-multiple-filters-and-using-them-when-it-is-needed) - 1 comment, 1 upvote - [What is SQL Developer used for?](https://www.g2.com/discussions/what-is-sql-developer-used-for) - 1 comment - [What is the use of SQL Developer?](https://www.g2.com/discussions/what-is-the-use-of-sql-developer) - 1 comment - [View SQL Developer pricing details and edition comparison](https://www.g2.com/products/sql-developer/reviews?focus_review=4316606&page=2&product_id=sql-developer§ion=pricing&secure%5Bexpires_at%5D=2026-05-23+00%3A32%3A53+-0500&secure%5Bsession_id%5D=a21b2ee6-898e-4bfd-a4e1-3063f525bcfc&secure%5Btoken%5D=2dcb23320bddd007db6d27d8da9c09ac8fb9627b0006c37315c185f75bb0641c&format=llm_user) ## SQL Developer Integrations - [Visual Studio Code](https://www.g2.com/products/visual-studio-code/reviews) ## SQL Developer Features **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis **Maintenance** - Data Migration - Backup and Recovery - Multi-User Environment **Security** - Data Encryption - User Access Control ## Top SQL Developer Alternatives - [Toad For Oracle](https://www.g2.com/products/quest-software-toad-for-oracle/reviews) - 4.4/5.0 (281 reviews) - [DbVisualizer](https://www.g2.com/products/dbvisualizer/reviews) - 4.7/5.0 (263 reviews) - [phpMyAdmin](https://www.g2.com/products/phpmyadmin/reviews) - 4.3/5.0 (165 reviews)