# PL/SQL Developer Reviews **Vendor:** Allround Automations **Category:** [Other Integrated Development Environments (IDE)](https://www.g2.com/categories/other-integrated-development-environments-ide) **Average Rating:** 4.5/5.0 **Total Reviews:** 13 ## About PL/SQL Developer IDE for Oracle software development (e.g. SQL and PL/SQL). Pricing and functionality place it in between Oracle SQL Developer (free) and Toad for Oracle ($$$$). The interface and feature set focuses on software developers and focused a little less on DBAs (Toad for Oracle is primarily DBA-focused). ## PL/SQL Developer Reviews ### 1. Best Development and query optimizer tool for Pl/SQL, SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Muzzi J. | Oracle EBS Techno Functional Consultant , Small-Business (50 or fewer emp.) **Reviewed Date:** January 05, 2023 **What do you like best about PL/SQL Developer?** This is the mandatory tool for oracle developers and DBA, its very use full for developing functions, procedures, packages, triggers and much more. Further more its also used for query optimization. **What do you dislike about PL/SQL Developer?** Sometimes taking too much time to return a query. If you open more then one window, also take hanging the computer. And it lags some time to run a complex query database. **What problems is PL/SQL Developer solving and how is that benefiting you?** Customization is available for any organization, so it helps to script reading, developing new queries for oracle reports and forms, also modify existing queries and tablets. ### 2. One of best oracle based development for production analyst - PL/SQL Developer **Rating:** 4.5/5.0 stars **Reviewed by:** Aadil A. | Support Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** July 12, 2022 **What do you like best about PL/SQL Developer?** Using PL/SQL it was easy to track or query or amend the package/stored procedure it's easy to track which is most efficient and very handy than other SQL applications. Also PL/SQL has the commit & Rollback options, where it doesnt create an impact while running update or delete or insert statement. My work is most dependant with the PL/SQL Developer to run the queries in databases. **What do you dislike about PL/SQL Developer?** Did not face any problems with PL/SQL other than few select or declare statements might take additional time as the size of the table might be in huge size that really take some time while executing. **What problems is PL/SQL Developer solving and how is that benefiting you?** As working in Warehouse Management System (WMS), I need to query or execute commands in oracle database (PL/SQL) and is easy to find the objects in the database and will be able to amend as well as test it and compile it in seconds. Save lots of time comparing using normal SQL apps. ### 3. Best software for track the PLSQL performance issues **Rating:** 5.0/5.0 stars **Reviewed by:** Shehan D. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 30, 2022 **What do you like best about PL/SQL Developer?** Using this tool it's easy to track which piece of code is taking much time from the whole logic flow. Furthermore, It's easy to get a profiler report as well as the session trace to analyze the performance issues further. **What do you dislike about PL/SQL Developer?** While debugging with the test window PLSQL developer Is very slow with complex logic codes. Most of the time it went to not responding mode. However, It's possible to kill the session and start the same again. **What problems is PL/SQL Developer solving and how is that benefiting you?** Backend development with oracle PLSQL and create packages. Debugging the packages and importing data through excel are beneficial functions when it comes to monitoring a Live system with the clone development environment. Therefore it's easy to migrate data from a live database to a clone database using the PLSQL developer. ### 4. perfect software for an oralce plsql dev. **Rating:** 4.5/5.0 stars **Reviewed by:** Roy N. | Senior Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 14, 2022 **What do you like best about PL/SQL Developer?** You can open multiple connections. You can change the keys. You can revisit the old queries. Plsql developer has a great debug menu. **What do you dislike about PL/SQL Developer?** the connections to databases sometimes does not work and need the exact tnsnames location, on the contrary of toad that can direcly ernters the connection address. when choosing a date sometimes the software freeze. **Recommendations to others considering PL/SQL Developer:** I have used most of the dev tools that a Plsql developer uses, which is the best. Of course, a few upgrades won't hurt, but I found most of what I needed in this software.! **What problems is PL/SQL Developer solving and how is that benefiting you?** I use Plsql for every day of work. It helps me connect directly to the database and do my queries; in addition, Plsql allows me to run and debug procedures and packages. The advantage of Plsql is the smoothness that he provides while working on a single database, multiple sheets, autocorrect ### 5. Best IDE for Oracle based scripts development - PL/SQL Developer **Rating:** 4.0/5.0 stars **Reviewed by:** Aritra M. | Business Analyst IT Solutions and Digital Transformation, Small-Business (50 or fewer emp.) **Reviewed Date:** December 06, 2021 **What do you like best about PL/SQL Developer?** There are many nice features of the PL/SQL Developer, those are : 1. One and only dedicated PL SQL development IDE. In the market there are many IDEs, which are primamrily for SQL script development, and additionaly supports PLSQL development But this IDE is specificaly built for PLSQL purpose only. 2. Provides a wide range of assistance to the programmer. Code Assistant automatically provides information about database objects. It has a beautifier, that allows me to format the PL/SQL code through a custom defined set of rules. 3. Syntax Highlighting, is the most attractive feature for me. 4. THE PL/SQL Developer is a multi-threaded IDE. This allows me to develop multiple scripts and at the same time execute some as well. 5. Built in integrated debugger, serves as a great tool for developers like us. This feature allows me to Step In, Step Over, Step Out, a query and run until exception. 6. Very easy for beginners to jump in to plsql development using this IDE. The UI is very crisp and clear. 7. It has multiple plugins, that serves the purpose of Customized Syntax Highlighting, FTP File Interface, Version Control Interface etc. **What do you dislike about PL/SQL Developer?** 1. The pricing can be made better, the structure punishes having lesser number of licenses for a team. All teams are not large, some are small with 10-20 people only. 2. The IDE is machine resource (RAM, CPU) hungy. If you leave it idle for half an hour, it will consume a major portion of your memory and processor. 3. The UI is very clean, but at the same it looks a bit basic. New skins/themes can be added to make this more vibrant. 4. Data Base connection drops frequently for users whose machine is connected to multiple vpns / network encryptions. **What problems is PL/SQL Developer solving and how is that benefiting you?** We, as a team, develop PL SQL codes for automated database scripts. Along with PLSQL codes, we also write and unit test and debug SQL scripts. We build database monitoring scripts and application auditing scripts. We manage database objects, do data modeling to create Entity Relations. Also, as a secondary usage, we use this software to train freshers who join our team for oracle database projects. ### 6. Mature Oracle PL/SQL IDE focused on the Programmer/Analyst **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** August 04, 2021 **What do you like best about PL/SQL Developer?** * The focus is on programmer/analyst productivity, rather than DBA-level needs (e.g. account maintenance, etc). * By this I mean they've developed a powerful database browser that integrates with their solid, extensible code editor. So it's easy to search, review, edit and check-in your database and code objects. * I love the ability to choose the function keys for every bit of functionality in the product, so I can be most productive. * The Code Beautifier allows you to develop and enforce code style standards, and it can guide you to use standard naming conventions. * When writing SQL or PL/SQL, you can select a keyword and hit a single key to seach Oracle reference documents for assistance. * The Code Assistant provides help with the call syntax to standard Oracle or your custom routines. * Editable code templates let you easily drop standard coding methods right into your program. * The code testing window, with included debugger, is very powerful, yet very usable for quickly running a code fragment. It also includes a Test Manager, which lets you develop suites of test scripts for large-scale regression testing. * PL/SQL Developer also supports extending the product via creating plug-ins, to enhance the editor and other product functionality. * Direct integration with code repository tools - Git and SVN. * The product continues to add new productivity improvements with each major version, though they aren't always features I use. **What do you dislike about PL/SQL Developer?** * The look-and-feel are a bit dated, but they work fine for this old-school programmer. * There are so many features that it takes time to learn how to use some of the power under the hood, and some features overlap enough that you're not always sure which feature should be used. * Some features (e.g. Data Modeling and charting query results) have very simple implementations and haven't been enhanced much in years. * New product releases haven't rolled out major new features in a few years. It's still being actively developed, but I haven't noticed any wow-factor changes in a while. * Some of my teammates use Macs, but PL/SQL Developer doesn't offer a Mac version and they don't like using it under Parallels. **Recommendations to others considering PL/SQL Developer:** Review the documentation to learn about the features. You'll see it's developer-focused, yet provides very good access to database objects and status. **What problems is PL/SQL Developer solving and how is that benefiting you?** We're a smallish team of Oracle programmers maintaining a fairly large code base that's been developed over decades. Plus we're developing new applications that support the main product all the time. PL/SQL Developer lets us search, edit and debug the way we want, while allowing us to apply team standards. ### 7. best developer tool **Rating:** 5.0/5.0 stars **Reviewed by:** Abdul R. | Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** February 10, 2022 **What do you like best about PL/SQL Developer?** just connect with the database write a query and run within a few seconds output main thing is auto-complete, insert like table name and processors many futures are available my work is almost 90% on PL SQL Developer very easy to manipulate variables in programs **What do you dislike about PL/SQL Developer?** still not face any problem that really hurt me I am very happy with this just start developer and work no need extra effort very easy to execute commands I am very happy with this **Recommendations to others considering PL/SQL Developer:** please use this software one of the best developer tools before compiling report query analizer tool **What problems is PL/SQL Developer solving and how is that benefiting you?** very easy execute sequence query we had a big problem to write a query and show output after developer very easy for use before compile program just check on Developer to result ### 8. Excellent tool for multiple Database connection **Rating:** 4.5/5.0 stars **Reviewed by:** Nehal B. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** February 26, 2022 **What do you like best about PL/SQL Developer?** its user friendy tool which offers single query execution with multiple query in note pad also data migration part is good all the tabs like debug session own project development comes handy a lot **What do you dislike about PL/SQL Developer?** The tool makes things really easy handling data and running queries efficiently still i belive adding more colors and giving 3d effect to the option s and tabs like other tools use would greatly improve user experience **What problems is PL/SQL Developer solving and how is that benefiting you?** I am ETL developer, so most of my task is to develop store procedures and run multiple queries at a time save quries save data extract data transform data jump onto multiple databases at a time so this all tasks are efficiently handled by this tool ### 9. Basic Oracle PL/SQL Desktop Client **Rating:** 3.5/5.0 stars **Reviewed by:** Ehtesham K. | Software Development Team Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** February 03, 2022 **What do you like best about PL/SQL Developer?** It can be used for both designing and administration of the database. For example in Designing: working on queries, procedures, views or in Administration: creating, importing, exporting, optimizing databases. **What do you dislike about PL/SQL Developer?** User interface (UI) is quite old fashioned like working on 90s software tools. Similarly this software limits you to compile the procedure or views of you are finding some database objects simultaneously. **What problems is PL/SQL Developer solving and how is that benefiting you?** Mostly related to managing database of Oracle 12c. It's basically a cheap software to be very honest and simple to start with basic functionality of the databases. ### 10. PL/SQL Developer To Acces Oracle Database **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** July 26, 2022 **What do you like best about PL/SQL Developer?** Executes Continuously the SQL statement you want to use **What do you dislike about PL/SQL Developer?** Executes continuously the SQL statement you want to use, even if you want just 1 execution **What problems is PL/SQL Developer solving and how is that benefiting you?** Accessing a large Oracle Database effortlessly ### 11. Best Tool for SQL Developer/Administrator **Rating:** 5.0/5.0 stars **Reviewed by:** Risha T. | Application Developer, Enterprise (> 1000 emp.) **Reviewed Date:** May 16, 2022 **What do you like best about PL/SQL Developer?** Easy query run engine with auto query format. Export data in multiple formats like CSV, XLS. **What do you dislike about PL/SQL Developer?** Not found any major issue, but UI can be a little better. **What problems is PL/SQL Developer solving and how is that benefiting you?** Daily database administration and monitoring. Software development. ### 12. PLSQL is a Handy tools for developers **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** January 15, 2022 **What do you like best about PL/SQL Developer?** Save time, easy to use and get my job done in seconds **What do you dislike about PL/SQL Developer?** You must get approve to buy the license, however the price is reasonable **What problems is PL/SQL Developer solving and how is that benefiting you?** Easy to find the objects in the database from plsql developer, you may edit , test it and compile it in seconds. Save lots of time comparing using sqlplus. ### 13. Does the job! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Management Consulting | Mid-Market (51-1000 emp.) **Reviewed Date:** October 21, 2021 **What do you like best about PL/SQL Developer?** I like the flexibility to pull data from many, many sources and save queries for later use. **What do you dislike about PL/SQL Developer?** It is not user-friendly if it is your first time using the software. It would be best if you were trained by someone familiar. **What problems is PL/SQL Developer solving and how is that benefiting you?** We are solving data management and analytics and confirming data entry compliance. ## PL/SQL Developer Discussions - [What does Pl/Sql Developer do?](https://www.g2.com/discussions/what-does-pl-sql-developer-do) - [What are the features and benefits of PL SQL?](https://www.g2.com/discussions/what-are-the-features-and-benefits-of-pl-sql) - [What does a PL SQL developer do?](https://www.g2.com/discussions/what-does-a-pl-sql-developer-do) - [How to get valid alternatives listed in review?](https://www.g2.com/discussions/how-to-get-valid-alternatives-listed-in-review) - 1 upvote - [View PL/SQL Developer pricing details and edition comparison](https://www.g2.com/products/pl-sql-developer/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-07+05%3A01%3A00+-0500&secure%5Bsession_id%5D=8f1dbb10-becb-49fc-97b6-a4787aff929f&secure%5Btoken%5D=1404b066f14ca87ec7c74d6a7acd82992ef975a649d9822f101b28522a70ffda&format=llm_user) ## Top PL/SQL Developer Alternatives - [WebStorm](https://www.g2.com/products/webstorm/reviews) - 4.5/5.0 (495 reviews) - [Studio 3T](https://www.g2.com/products/studio-3t/reviews) - 4.5/5.0 (190 reviews) - [Coder](https://www.g2.com/products/coder/reviews) - 4.3/5.0 (198 reviews)