PL/SQL Developer Reviews & Product Details

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

You can open multiple connections.

You can change the keys.

You can revisit the old queries.

Plsql developer has a great debug menu. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

* 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. Review collected by and hosted on G2.com.

* 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. Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Executes Continuously the SQL statement you want to use Review collected by and hosted on G2.com.

Executes continuously the SQL statement you want to use, even if you want just 1 execution Review collected by and hosted on G2.com.