PL/SQL Developer - Plug-Ins

This page 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.

If you are interested in creating your own Plug-Ins you should read the Plug-In documentation and demo's in the PlugInDoc directory included with the PL/SQL Developer download.
If you have created a Plug-In that you think is useful for the general PL/SQL Developer community, you can have it included on this page by submitting it to support@allroundautomations.com. Alternatively you can simply contact us if you are using a product that you think is suitable for integration with PL/SQL Developer, and we will consider creating a Plug-In for it.

32 bit and 64 bit versions
Note that for the 32 bit and 64 bit versions of PL/SQL Developer you will need to download the corresponding Plug-In version. A 32 bit Plug-In will be ignored by the 64 bit version of PL/SQL Developer and vice versa.

Active Query Builder
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
   
Requirements Download
PL/SQL Developer 7.0.0 32 bit: ActiveQueryBuilder141x32.exe (version 1.4.1) 3.5 MB
64 bit: ActiveQueryBuilder141x64.exe (version 1.4.1) 4.2 MB
plsqldoc
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. See plsqldoc110.txt for details.
Version 1.1.4: released on November 5, 2003. See plsqldoc114.txt for details.
Version 1.1.6: released on March 6, 2004. See plsqldoc116.txt for details.
Version 1.2.0: released on April 30, 2005. See plsqldoc120.txt for details. 
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
Requirements Download
PL/SQL Developer 5.1.2 32 bit: plsqldoc130x32.exe (version 1.3.0) 2.6 KB
64 bit: plsqldoc130x64.exe (version 1.3.0) 3.1 MB

Version Control Interface
The VCS Plug-In integrates PL/SQL Developer with any Version Control System that supports Microsoft's SCC Interface Specification. This will allow you to perform Version Control operations such as check in, check out and view differences directly from within PL/SQL Developer, without the need to switch to your Version Control software.

Products that support Microsoft's SCC Interface include:

  • Microsoft Visual SourceSafe
  • Merant (Intersolv) PVCS
  • MKS Source Integrity
Fixes in 1.0.4: Toolbar buttons were not correctly updated after check-in / check-out.
Fixes in 1.0.5: Project root directory could sometimes be determined incorrectly.
Fixes in 1.0.6: Performance improvement when opening large projects.
Fixes in 1.0.7: Check-in and Undo Check-out were enabled when file was checked out by another user. File selector would not be updated correctly when changing status filter.
Fixes in 1.1.0: Included an option to add buttons on the toolbar.
New in 1.2.0: Allow version control of DB Objects.
Added Close Project menu item.
New in 1.2.3: Updated to work with PL/SQL Developer 8.0.
Fixed problem with incorrect disabled menu items
Fixed problem with not always refreshing file after checking out.
New in 1.2.4: Updated to work with PL/SQL Developer 9.0.
Help button for link to pdf documentation
New in 1.2.5: Updated to work with PL/SQL Developer 12.0.
New in 1.2.6: Added a VCS Ribbon Tab and popup menu icons for PL/SQL Developer 12.0.
Fixed: Properties, Differences and History items could be enabled when no file was open.
Requirements Download
PL/SQL Developer 2.1 (5.1.2 recommended)
An SCC compliant Version Control System
32 bit: VCS126x32.exe (version 1.2.6) 1.8 MB
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. 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
Requirements Download
PL/SQL Developer 4.0 32 bit: FTP231x32.exe (version 2.3.1) 3.6 MB
64 bit: FTP231x64.exe (version 2.3.1) 4.3 MB
Customized Syntax Highlighting
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
Requirements Download
PL/SQL Developer 3.0 32 bit: HighLighting120x32.exe (version 1.2.0) 3.6 MB
64 bit: HighLighting120x64.exe (version 1.2.0) 4.4 MB
PL/SQL Wrapper Interface
Oracle's PL/SQL Wrapper is a standard command-line utility to encrypt the source code of your PL/SQL program units. The encrypted source files are unreadable, but can still be compiled into a database. This is useful when you want to distribute a client/server application but need to protect the intellectual property of your server software.

This Plug-In makes it easy to wrap your program units from within PL/SQL Developer. Just select the program unit in the Object Browser and select 'Wrap program unit' from the Tools menu.

New in version 1.1.0: Updated to work with PL/SQL Developer 12.0.

Requirements Download
PL/SQL Developer 2.1
Oracle's PL/SQL Wrapper (e.g. wrap23.exe, wrap80.exe)
32 bit: Wrap110x32.exe (version 1.1.0) 1.5 MB
64 bit: Wrap110x64.exe (version 1.1.0) 1.7 MB

The following Plug-Ins are developed by other PL/SQL Developer users. They are therefore not supported by Allround Automations. Questions and suggestions about these Plug-Ins can be directed to the respective authors.

rrProject

The rrProject Plug-In is a freeware toolset aimed to increase productivity of PL/SQL Developer users. It includes the following tools:

  • IDE Enhancements (include Window List Highlight Tool)
  • Command Wizard
  • Object Browser Enhancements (include Object Privileges Tool)
  • Code Editor Wizard (include Code Context List Wizard)
  • Connection Tools (include Advanced Window Indicator Tool)
  • Text Editor Enhancements (include Code Input Wizard)
  • Compare Tools

To install, unzip archived package to PL/SQL Developer's PlugIns subdirectory.

Changes in 1.2.0: Wizard: IDE Enhancements: Added Window List Highlight Tool.
Wizard: Connections Tools: Added Advanced Window Indicator Tool (V9.X and above).
Wizard: IDE Enhancements: Window autocreation Tool: Added support Window List.
Wizard: Objects Browser Enhancements: "What" Parameter Job Tool: Added support sole procedure.
Changes in 1.2.1: Wizard: Code Contents List Wizard: Added indication of procedures visibility.
Wizard: Objects Browser Enhancements: "What" Parameter Job Tool: Added scheduler jobs.
Changes in 1.2.2: Wizard: Code Editor Wizard: Added Section Selection Tool.
Wizard: Code Editor Wizard: Added Jump to Section Ending Tool.
Wizard: Code Editor Wizard: Added Jump to Section Start Tool.
Wizard: Text Editor Enhancements: Extended Enter Tool remodeling to New Line Tool.
Wizard: Objects Browser Enhancements: "What" Parameter Job Tool: Added support of any objects.
Wizard: Code Contents List Wizard: Fixed icon for private procedures.
Changes in 1.2.3: Engine: Added Boot wizard dialog.
Wizard: IDE Enhancements: Window autocreation Tool: Added message about missing templates path.
Wizard: Connections Tools: Advanced Window Indicator Tool: Fixed program hanging when child window creating.
Wizard: Connections Tools: Main connection Indicator Tool: Fixed drawing error at scrolling.
Changes in 1.2.4: Engine: Bug fix for new installation.
Wizard: Compare tools: Compare Windows Tool: Added 'Beautify text' and 'Selection' options.
Wizard: IDE Enhancements: Added Child Window Arrangement Tool.
Changes in 1.2.5: Wizard: Objects Browser Enhancements: "What" Parameter Job Tool: Fixed repeated calls.
Engine: Improved behavior for Windows 7.
Wizard: Text Editor Enhancements: Extended Home Tool: Added support Tab-character.
Engine: Improved behavior for V10.0, V11.0.
Wizard: Text Editor Enhancements: Added Selected Lines Move Up Tool.
Wizard: Text Editor Enhancements: Added Selected Lines Move Down Tool.
Wizard: Text Editor Enhancements: Added Extended Tab Tool.
Wizard: IDE Enhancements: Child Window Arrangement Tool: Checked PL/SQL Developer version.
Wizard: Connections Tools: Advanced Window Indicator Tool: Checked 'Set window indicator' option.
Changes in 1.3.0: Engine: Many changes for support version V12.X

Developed by Alex Rutkovsky.

Requirements Download
PL/SQL Developer 7.0 32 bit: rrPLDPlugin.zip (version 1.3.0) 1.7 MB
Save with "show errors"
This Plug-In allows you to save a file with an additional SHOW ERRORS command appended at the end, so that when your file is executed in SQL*Plus it will automatically show any compilation errors. The "File" menu is extended with a "Save with show errors as" and a "Save with show errors" menu item. For more information, see http://apps-oracle.ru/mysave-plug-in-for-plsql-developer.

Developed by Ostapishen A.V.

Requirements Download
PL/SQL Developer 5.1.2 32 bit: MySave.rar (version 1.2) 231 KB
Connection Manager
The Connection Manager Plug-In allows you to manage an hierarchical list of connection profiles, with or without passwords. Passwords can be encrypted with a master password. The Connection Manager can replace PL/SQL Developer's standard logon dialog if it is started with the NoLogon parameter, and if you use the Plug-In buttons or menu items to log on.
 
Requirements Download
PL/SQL Developer 7.1 32 bit: KPConnectionManager.zip (version 1.3.1.0) 710 KB
OrindaBuild Java Code Generator
The OrindaBuild Plug-In integrates PL/SQL Developer 7.0 with OrindaBuild, which generates Java source code to call your PL/SQL Procedures and Functions.

Key Features
Examines your PL/SQL procedures and functions and automatically writes all the class files needed to call them from Java.
Writes JDBC calls for PL/SQL procedures that take arrays, records and %ROWTYPEs as parameters.
Creates Java classes to match records, table rows, cursors and arbitrary SQL statements.
Generates all the classes needed to call your PL/SQL as part of a Java service.
Does not require schema changes or the use of a precompiler.
Writes human readable Java source code.
Wizard based interface makes configuration easy.
Select objects for code generation by right-clicking.
All needed source is generated or provided. No mysterious run time executable classes.
Integrated with the PL/SQL Developer 7.0 GUI.
Sample schema and generated code are available here.
Full on line documentation available here.
Full license is US$299. No obligation 30 day demo available.
Requirements Download
PL/SQL Developer 7.0
Sun Java JDK 1.3 or higher
Oracle 8.1.5 or higher
32 bit: OrindaBuild Download Page (8.5 MB)
Emberiza Plug-Ins
On the Emberiza web site you can find the following Plug-Ins:

Browser Extender
The Browser Extender Plug-In is a very powerful extension to PL/SQL Developer. It allows you to add your own menu items to the browser popup menu. You can create your own specific commands for specific browser items. For example: show the record count of a table, truncate a table, display if a program unit is in the library cache, and so on...

A new version 2.5 is released with additional features, which is available as a commercial product. The old version 2.0 is still available for free.

Plot Window
The Plot Window Plug-In allows you to change PL/SQL Developer into Oracle performance monitoring tool. It adds a new kind of child window with ability to draw graphs based on data queried directly from Oracle database.

Save Bookmarks
The Save Bookmarks Plug-In allows storing and restoring of bookmarks from windows with an editor. Bookmarks are saved after file save or close, and loaded when a file is opened. Bookmarks are saved in a file with the same name as the opened file but with a '.bookmarks' extension.

Change Password
The Change Password Plug-In allows you to conveniently manage passwords. It offers several options and allows you to view SQL code that will be executed.

Google Search
The Google Search Plug-In allows you to quickly perform a Google search based on text in an editor.

Window Manager
The Window Manager Plug-In is a simple replacement for Window List dialog.

Developed by Joachim Rupik
Emberiza Software s.c.

BAR Solutions Plug-Ins
On the BAR Solutions web site you can find the following Plug-Ins:

Comment lines
Use this plug-in to (un)comment lines with line comments (--). If you install this Plug-In, you will get additional menu items to comment and uncomment a selection. You can assign shortcut keys to the menus for quick access.

Save separate
Use this plug-in to save the spec and body of a package in separate files.

Favorites
Use this plug-in to keep your favorite files (scripts) handy all the time.

Compile current
Use this plug-in to compile the current tab.

Reconnect
Use this plug-in to reconnect to the database you were last connected to. For instance after a nightly shutdown of the database.

Shift tab
Use this plug-in to shift-tab through your code.

Toggle Read-Only
Use this plug-in to toggle the read-only state of your window.

Template
Use this plug-in to use templates like the way the Delphi IDE works.

Developed by Patrick Barel
http://www.bar-solutions.com
SmartEd
SmartEd (Smart Editor) allows you to auto-complete all keywords defined in PL/SQL Developer. After typing the first character(s) you can press TAB to complete the keyword. If multiple keyword match, a list is displayed and you can select the appropriate keyword.
SmartEd also recognizes all keywords added by the Syntax Highlighting Plug-in.

New in version 1.1
- fixed error not permitting several plug-ins like SmartEd to work together
- fixed several algorithm errors

New in version 2.0
- PL/SQL Developer template execution support added
- SmartEd statistics added
- Keyword and template window appearance changed
   (window is now resizable and its current size is stored in registry)
- Setup Dialog added. User can setup the hotkeys for keyword autocompletion
   and template executions
- Plug-In configuration panel support added
   (Tools/Configure Plug-Ins... menu item)

Developed by Oleg Tyurin

Requirements Download
PL/SQL Developer 4.0 32 bit: smarted.zip (version 2.0) 490 KB
NamedSQL
Allows you to easily store and retrieve frequently used code. (Developed by Tiger)
Requirements Download
PL/SQL Developer 2.1 32 bit: namedsql.zip 95 KB
NamedSQL (DB)
With this Plug-In you can save frequently used SQL code in the database. It allows you to name and categorize the SQL code, and to search within these categories when you want to reuse the SQL code later. (Developed by Péter Serfel)
Requirements Download
PL/SQL Developer 4.0 32 bit: nsqldb.zip 194 KB
FindAll
Displays a window with all lines in the current editor that match your search string. Specify the search string by selecting text in the editor or start FindAll and enter the search string there. Click on a matching line and the editor display is changed to show that line. Regex searches are also supported.
 
2003/11/18: Select all gave an error and there were 2 menu items that did nothing.
2004/03/12: Use Checkbox vice RadioButton to use RegExp.
Del and backspace keys work in combobox.
Combobox expands/contracts as the window is resized.
2004/03/15: The Search button wasn't enabled if you highlighted something before invoking the plugin.
OR searches, where the search string contains a |, didn't do an OR search.
Added a hint to the ? button next to the combobox.

Developed by Scott Mattes

Requirements Download
PL/SQL Developer 5.1.3 32 bit: findall.zip 270 KB
Sort
Select some lines in the editor and select Sort and decide whether you want case sensitive or insensitive and the selected lines are replaced with a sorted version.
 
2004/03/12: Detect tabs in lines to be sorted, prompts for replacing (uses 2 spaces per tab).

Developed by Scott Mattes

Requirements Download
PL/SQL Developer 5.1.3 32 bit: sort.zip 200 KB
Scale
Select something in the editor, or copy some text to the clipboard, and select Scale and a window opens with a scale and the lines.
 
2003/11/13: The scale line only went to 500.
2004/03/12: Add octal display of char at cursor.
Enlarged area to display on statusbar.
Change scale size when contents of window are changed.
Scrolls better.

Developed by Scott Mattes

Requirements Download
PL/SQL Developer 5.1.3 32 bit: scale.zip 220 KB
CompareSource
This is a front-end for the ExamDiff program that comes with PL/SQL Developer.
You can compare the source currently displayed in the Program window to code in any other accessible Schema, or in a file on your PC.
 

Developed by Scott Mattes

Requirements Download
PL/SQL Developer 6.0 32 bit: comparesource.zip 240 KB
Easy Bookmarks
Provide Borland IDE Style Bookmarks using hot keys:
 Ctrl+Shift+# - set bookmark
 Ctrl+# - goto bookmark
 
Version 1.0.1: Fixed bug with other symbols.
Version 1.0.2 Fixed Issue with PL/SQL Developer 7.1

Developed by Victor Shibaeff

Requirements Download
PL/SQL Developer 5.1
PL/SQL Developer 7.1
32 bit: Easy_BM.zip (1.0.1) 240 KB
32 bit: Easy_BM.zip (1.0.2) 50 KB (only for PL/SQL Developer 7.1 and higher!)
LBC Recall Named SQL
This Plug-In adds extensive store and recall options for queries. It allows access to the query history of PL/SQL Developer, and you can even use history files of other applications.
 
Version 1.01: Added the ability to change the menu structure of the plug-in.
Some cosmetic changes have been made and the ability to scale correctly at different resolutions has improved.
The Recall SQL form will now remember its last location.

Developed by Riley Carrier
Love Box Company, Inc.

Requirements Download
PL/SQL Developer 5.1 32 bit: LBCNamedSQL.zip 300 KB
LBC Table Sort/Filter
This plug-In allows you to select sort/filter options for queries. Selections will be saved for each instance/schema.
 
Version 1.01: Includes some user requested updates.

Developed by Riley Carrier
Love Box Company, Inc.

Requirements Download
PL/SQL Developer 5.1 32 bit: LBCTableFilter.zip 250 KB
Startup Options
With this plug-in PL/SQL Developer automatically opens files or creates new windows on startup.
 
Version 1.1: Added possibility to delay all actions until a connection is made.
Added the possibility to have new windows created each time a connection is made.
Windows that should be executed no longer try to execute when there is no connection.
The configuration tool has some minor improvements.
Added a bug that is generated when the ini-file has no items, and the configuration tool is run more than once.

Developed by Clouds®
thefonz79@hotmail.com

Requirements Download
PL/SQL Developer 5.1 32 bit: StartupOptions.zip 310 KB
Paste Options
With this Plug-In you can create multiple custom paste formats. You can add characters to the beginning or the end of the text that is pasted, replace characters and strip extra control characters.
 
Version 1.2: Added the possibility to add text at the start and end of each line.

Developed by Clouds®
thefonz79@hotmail.com

Requirements Download
PL/SQL Developer 5.1 32 bit: PasteOptions.zip 210 KB
Remote Command (rexec)
This Plug-In implements the rexec Unix shell command. This allows you to kill a server process (menu Session -> Kill server process by SID), and you can run non-interactive Unix commands in a command window.

Developed by Andyca Chiou

Requirements Download
PL/SQL Developer 6.0 32 bit: rexec.zip 350 KB
Quick/ER
Quick/ER gives you the possibility to quickly create ER (entity relation) diagrams of your database objects.
This is a trial version, for additional details see www.gotterup.net.
 
Version 2.0:  
Version 2.5: Quick/ER is back with a new version, click here for details.

Developed by Poul Gøtterup

Requirements Download
PL/SQL Developer 7.1.3 (or higher) 32 bit: http://www.gotterup.net/
User-defined Text Export
When you install this Plug-In you get an additional user definable text export option (next to the html, xml, csv and tsv formats). This option will allow you to save files in your preferred text format. You can define separators, quotes and escape characters. You can also export in fixed length format.
 
Version 1.1: - allows columns include to / exclude from export
- allows first column (Line No) always include to / exclude from export

Developed by Dmitry Arefiev
http://www.da-soft.com

Requirements Download
PL/SQL Developer 6.0 32 bit: textexport.zip 320 KB
TNS Editor
A quick and easy editor for your TNSNames file. Includes Delphi source code.
 

Developed by Dave Derrick

Requirements Download
PL/SQL Developer 6.0 32 bit: TNSEditor.zip 370 KB
LuaPlSql
LuaPlSql is a Lua Plug-In framework for the PL/SQL Developer IDE. You can program your own Add-ons for the Lua Plug-In to extend the functionality of PL/SQL Developer. Functions in an Add-on can be added to the PL/SQL Developer menu, and can perform any kind of action: access the database, the Object Browser, the current window and editor and so on.

For general information about Lua, see: http://www.lua.org/

Developed by Nodir Temirhodzhaev

Requirements Download
PL/SQL Developer 7.1 32 bit: http://luaforge.net/projects/luaplsql/
SUMSoft SVCO (Schema Version Control for Oracle)
The SVCO Plug-In for PL/SQL Developer gives you the possibility to use the complete SUMSoft SVCO functionality inside the PL/SQL Developer environment.

SUMSoft SVCO is an integrated version control solution for Oracle database server schema objects. You can track all schema objects changes direct within Oracle database. No extra version control tool is required. You can go on and use your favorite IDE for Oracle or even mix different tools. You can also integrate Schema Version Control for Oracle in your own development process.

Developed by SUMsoft Solutions
http://sumsoftsolutions.com/svco/index.html

Requirements Download
PL/SQL Developer 7.0 or newer
SVCO 1.0.0 or newer
Oracle 10g or 11g database
32 bit: svco_plsdev
TortoiseSVN-wrapper
If you use Subversion as Version Control System you can use this Plug-In to interface with the TortoiseSVN client. The advantage of this Plug-In over the general VCS Plug-In is that this one is specifically designed to interface with Subversion through the TortoiseSVN client, allowing access to all specific features.


Developed by Otto Noll.

Requirements Download
PL/SQL Developer 7.1
TortoiseSVN client
32 bit: http://plsqldev-svn-plugin.tigris.org/
Query Execution Notifier
A handy little Plug-In that gives you a notification when a long running query has finished. It only shows when you have switched to another application.
C++ source files are included.

Developed by Andrey Grigoriev. Ported to Visual Studio 2015 32 bit & 64 bit by Nicolas Denis.
 
Requirements Download
PL/SQL Developer 7.1 32 & 64 bit: ExecuteNotifier.zip 61 KB