PL/SQL Developer

Save time and money on your PL/SQL Development

PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development.

For a brief description of the new features in version 15.0, visit the New Features page.

Features

Powerful PL/SQL Editor

With its Syntax Highlighting, SQL and PL/SQL help, Object Descriptions, Code Assistant, Compiler Hints, Refactoring, PL/SQL Beautifier, Code Contents, Code Hierarchy, Code Folding, Hyperlink Navigation, Macro Library and many other sophisticated features, the Unicode compliant editor will even appeal to the most demanding user.

Learn more 

Integrated Debugger

The integrated debugger offers all features you could wish for: Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View & Set Variables, View Call Stack, and so on. You can debug any program unit without making any modification to it, including triggers and object types.

Learn more 

PL/SQL Beautifier

The PL/SQL Beautifier allows you to format your SQL and PL/SQL code through a user-defined set of rules. Your code can automatically be beautified when you compile, save, or open a file. This feature will increase your coding productivity and will improve the readability of your PL/SQL code if you are working in large project teams.

Learn more 

Multi-threaded IDE

PL/SQL Developer is a multi-threaded IDE. This means that you can continue to work as SQL queries are executing, PL/SQL programs are executing, debug sessions are running, and so on. It also means that the IDE will not “hang” if you make a programming error: you can break execution or save your work at any time.

Easy installation

No middle-ware required other than Oracle Net. No database object installation. Just a simple one-button installation procedure and you’re ready to use it.

Trial version

You can download a fully functional 30-day trial version to try out PL/SQL Developer yourself. If after 30 days you can’t imagine how you’ve ever been able to work without PL/SQL Developer, you can visit our ordering page for ordering details and price information. We have a customer list available if you want to get an impression of what organizations are using PL/SQL Developer.

Pricing & Licensing

PL/SQL Developer licenses are per named user, and not per PC, Server, Database or Location. Therefore you need just one license for one named user, even if you are running multiple instances on multiple machines. For complete license terms you can download our License Agreement.

If you order a Support Contract with your PL/SQL Developer licenses, you are entitled to receive technical support by e-mail for the period of 1 or 3 years. You can order the support contract directly with a PL/SQL Developer license, or at a later time. The support contract can be renewed when it expires.

Licenses Annual Support Contract
Single user USD 243.00 Single user USD 42.00
5 users USD 729.00 5 users USD 126.00
10 users USD 1,215.00 10 users USD 210.00
20 users USD 1,620.00 20 users USD 280.00
30 users USD 2,025.00 30 users USD 350.00
50 users USD 2,835.00 50 users USD 490.00
100 users USD 4,050.00 100 users USD 700.00
Unlimited USD 8,100.00 Unlimited USD 1,400.00

 

People love using PL/SQL Developer

Plug-ins

This section contains Plug-Ins for PL/SQL Developer that make use of the Plug-In interface, which allows you to develop DLL’s that are automatically picked up by PL/SQL Developer and are integrated into its IDE.

Active Query Builder

This a replacement for the standard Query Builder.
X
Plug-in
Active Query Builder

Download

This a replacement for the standard Query Builder. This one is based on the Active Query Builder component by Active Database Software. It offers additional features like unions, nested joins and sub-queries.

Version 1.4.0: released on March 22, 2012
Updated to work with PL/SQL Developer 9.0
Improved speed
Version 1.4.1: Compatibility with PL/SQL Developer 12.0
Version 1.5.0: Updated for PL/SQL Developer 15.0
User and Filter selector now matches the Object Browser

Requirements:
PL/SQL Developer 5.1.2 or later

Plsqldoc

The plsqldoc Plug-In allows you to easily generate and view HTML documentation for functions, procedures, packages, types, tables and views.
X
Plug-in
Plsqldoc

Download

The plsqldoc Plug-In allows you to easily generate and view HTML documentation for functions, procedures, packages, types, tables and views. The documentation is derived from the definition and the comments of these objects, in a similar way as Javadoc for the Java programming language.

Version 1.1.0: Released on July 17, 2003.
Version 1.1.4: Released on November 5, 2003.
Version 1.1.6: Released on March 6, 2004.
Version 1.2.0: Released on April 30, 2005.
Version 1.2.1: Released on October 13, 2011
Help button for link to pdf documentation
Default root directory changed to “My Documents\plsqldoc”
Version 1.2.2: Released on January 16, 2012
Fixed “List index out of bounds” error during document generation
Version 1.3.0: Compatibility with PL/SQL Developer 12.0
Version 1.4.0: Released on June 20, 2022
Updated for PL/SQL Developer 15.0

Requirements:
PL/SQL Developer 5.1.2 or later

 

FTP File Interface

The FTP File Interface Plug-In allows you to load and save files via the ftp protocol from within PL/SQL Developer.
X
Plug-in
FTP File Interface

Download

The FTP File Interface Plug-In allows you to load and save files via the ftp protocol from within PL/SQL Developer. This gives you the possibility to store your files on a unix or linux server or even on the internet.

Fixes in 1.1.0: Fixed an Access Violation that could occur when connecting to the server.
New in 2.0.0: New version with support for Secure FTP (SFTP).
Fixes in 2.0.8: Improved the SFTP interface.
Fixes in 2.1.0: Improved the (S)FTP interface.
Fixed visual issue with profile list in file dialog
Added Timezone preference to correct time difference on server
Fixes in 2.2.0: File dialog opens with focus on filename field
File save now has a default filename
Improved date sorting in the file dialog
New in 2.3.0: Compatibility with PL/SQL Developer 12.0
New in 2.3.1: Opening a file over an SFTP connection could lead to a “cannot get file size” error
New in 2.3.2: Saved files over an SFTP connection could have CR/LF line breaks on Unix
Configuration form now has explicit OK and Cancel buttons
New in 2.4.0: Updated for PL/SQL Developer 15.0

Requirements:
PL/SQL Developer 4.0 or later

Customized Syntax Highlighting

With this Plug-In you can add your own keywords and assign any of the available highlighting schemes to them.
X
Plug-in
Customized Syntax Highlighting

Download

With this Plug-In you can add your own keywords and assign any of the available highlighting schemes to them. You can even define your own query to retrieve keywords from the database. This way you can easily add package names, table names, etc as keywords.

Version 1.2.0: Compatibility with PL/SQL Developer 12.0
Version 1.3.0: Updated for PL/SQL Developer 15.0

Requirements:
PL/SQL Developer 3.0 or later