|
|
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. |
| Active Query Builder |
| This a 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.
|
| 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.
| Requirements |
|
Download |
| PL/SQL Developer 5.1.2 |
|
plsqldoc.zip
(version 1.2.0) 990 KB |
|
| 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. |
| Requirements |
|
Download |
PL/SQL Developer 2.1 (5.1.2 recommended)
An SCC compliant Version Control System |
|
vcs.zip (version
1.2.0) 470 KB |
|
| 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 |
| Requirements |
|
Download |
| PL/SQL Developer 4.0 |
|
ftp2.zip (version 2.1.0) 1250 KB
ftp.zip (version 1.1) 380 KB |
|
| 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 retreive
keywords from the database. This way you can easily add package names, table names, etc as
keywords.
| Requirements |
|
Download |
| PL/SQL Developer 3.0 |
|
highlighting.zip
(version 1.0) 260 KB |
|
| 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.
Note: the source code of this Plug-In is included in the demo's of the Plug-In
documentation.
| Requirements |
|
Download |
PL/SQL Developer 2.1
Oracle's PL/SQL Wrapper (e.g. wrap23.exe, wrap80.exe) |
|
wrap.zip
(version 1.0.0) 150 KB |
|
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. |
| 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
|
|
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 |
|
smarted.zip
(version 2.0) 490 KB |
|
| PL/Shortcuts |
| A handy utility that can help you if you feel that you're typing the same
things over and over again. You can create your own shortcuts (e.g. 's*' for 'select *
from') and as soon as you type a shortcut in any editor it is immediately replaced by the
corresponding text. New version! (Fixes Ctrl-Tab
problem)
Developed by Tiger
| Requirements |
|
Download |
| PL/SQL Developer 2.1 |
|
shortcuts.zip
(version 1.2) 87 KB |
|
| NamedSQL |
Allows you to easily store and retrieve frequently used code. (Developed
by Tiger)
| Requirements |
|
Download |
| PL/SQL Developer 2.1 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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
|
| 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 |
|
Easy_BM.zip (1.0.1) 240
KB
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.
|
| 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.
|
| 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
|
| 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
|
| 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 |
|
rexec.zip 350
KB |
|
| Quick/ER |
| No longer supported by the developer!
|
| 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
|
| TNS Editor |
| A quick and easy editor for your TNSNames file. Includes
Delphi source code.
Developed by
Dave Derrick
|
| 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
|
| 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 |
|
svco_plsdev |
|
|