[plsqldeveloper plugin]ColumnEdit
[v2.0]
ColumnEdit plug-in.
Use this plug-in to add/replace to column selection.
////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2003-2013 Patrick Barel                                          //
// patrick@bar-solutions.com                                                  //
// http://www.oracledeveloper.nl                                              //
// http://bar-solutions.com                                                   //
// http://blog.bar-solutions.com                                              //
////////////////////////////////////////////////////////////////////////////////
// Use this plug-in to add/replace to column selection                        //
//                                                                            //
// Installs menu-items:                          Hotkey (advice)              //
//    Edit / Selection / Column Edit (Replace)   SHIFT+CTRL+X                 //
//    Edit / Selection / Column Edit (Add)       SHIFT+CTRL+V                 //
//                                                                            //
//                                                                            //
// (c) 2003-2013: Patrick Barel                                               //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  V1.1   | PBA | Added posibility to add text before or after selection     //
//  v1.2   | PBA | Added option to save text in add or replace window         //
//  v2.0   | PBA | Updated for PL/SQL Developer v10                           //
////////////////////////////////////////////////////////////////////////////////


[plsqldeveloper plugin]commentline
[v2.3]
Comment lines plug-in.
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.
////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2003-2013 Patrick Barel                                          //
// patrick@bar-solutions.com                                                  //
// http://blog.bar-solutions.com                                              //
// http://bar-solutions.com                                                   //
////////////////////////////////////////////////////////////////////////////////
// Use this plug-in to (un)comment lines with line comments (--)              //
// eg: SELECT emp.empno                     SELECT emp.empno                  //
//          , emp.ename                           , emp.ename                 //
//          , emp.deptno                    --      , emp.deptno              //
//          , dept.deptno                   --      , dept.deptno             //
//          , dept.dname                    --      , dept.dname              //
//          , dept.loc                            , dept.loc                  //
//       FROM emp, dept                       FROM emp, dept                  //
//      WHERE emp.deptno = dept.deptno       WHERE emp.deptno = dept.deptno   //
//                                                                            //
// Installs menu-items:                    Hotkey (advice)                    //
//    Edit / Selection / Comment Lines     CTRL+-                             //
//    Edit / Selection / Uncomment Lines   SHIFT+CTRL+-                       //
//                                                                            //
// Thanks to:                                                                 //
//  Theo Tol and Michel Draaijer for testing this plug-in.                    //
//                                                                            //
// (c) 2003-2007: Patrick Barel                                               //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  v1.1   | PBA | Changed behaviour to be more like The Golden Retriever     //
//  v1.2   | PBA | Comment indicator doesn't have to be at start of line      //
//         |     | anymore. Leading spaces will be ignored.                   //
//  v1.3   | PBA | Enhancement request by Jason Vogel (jvogel@ahslink.com)    //
//         |     | The cursor shouldn't move when you comment a block         //
//         |     | (example were "^" is the cursor)                           //
//         |     |                                                            //
//         |     | text1                                                      //
//         |     | text2                                                      //
//         |     | text3                                                      //
//         |     | ^                                                          //
//         |     |                                                            //
//         |     | Cursors moves to                                           //
//         |     | --text1                                                    //
//         |     | --text2                                                    //
//         |     | --text3^                                                   //
//  v1.4   | PBA | Changes because of the changes in Version 7.1              //
//  v2.0   | PBA | New implementation to use common code in all plugins       //
//  v2.1   | PBA | Added toolbarbuttons                                       //
//  v2.2   | PBA | Fixed an issue when the comment is not at the start of     //
//         |     | a line and there is no selection                           //
//  v2.3   | PBA | Updated for PL/SQL Developer v10                           //
////////////////////////////////////////////////////////////////////////////////


[plsqldeveloper plugin EditorEnhancement
[v2.0]
Editor Enhancement plug-in.
Use this plug-in to enhance the editor.
////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2009-2013 Patrick Barel                                          //
// patrick@bar-solutions.com                                                  //
// http://blog.bar-solutions.com                                              //
// http://bar-solutions.com                                                   //
////////////////////////////////////////////////////////////////////////////////
// Use this plug-in replace tabs by spaces and to remove trailing spaces      //
//                                                                            //
// Installs menu-items:                            Hotkey (advice)            //
//  Edit / Enhancement / Remove trailing spaces                               //
//  Edit / Enhancement / Replace tab by spaces                                //
//  Edit / Enhancement / Remove blank lines                                   //
//  Edit / Enhancement / Add () around selection   CTRL-SHIFT-9               //
//  Edit / Enhancement / Add [] around selection   CTRL-[                     //
//  Edit / Enhancement / Add {} around selection   CTRL-SHIFT-[               //
//  Edit / Enhancement / Add '' around selection   CTRL-'                     //
//  Edit / Enhancement / Add "" around selection   CTRL-SHIFT-'               //
//  Edit / Enhancement / About                                                //
//                                                                            //
// Thanks to:                                                                 //
//   Billy Crosbie for the idea                                               //
//                                                                            //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  v1.1   | PBA | Cursor position is saved and reset                         //
//         |     | Save indicator is not updated if there were no changes     //
//  v1.2   | PBA | Did some work on the about window                          //
//  v1.3   | PBA | Added the option to remove blank lines                     //
//  v1.4   | PBA | Added possibility to add brackets around the selection     //
//  v2.0   | PBA | Added toolbarbuttons                                       //
//         |     | Updated for PL/SQL Developer v10                           //
////////////////////////////////////////////////////////////////////////////////


[plsqldeveloper plugin]ExecuteCurrentStatement
[v2.0]
Execute current statement plug-in.
Use this plug-in to execute the statement under the cursor.
////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2008-2013 Patrick Barel                                          //
// patrick@bar-solutions.com                                                  //
// http://bar-solutions.com                                                   //
// http://blog.bar-solutions.com                                              //
////////////////////////////////////////////////////////////////////////////////
// Use this plug-in to execute the statement under the cursor.                //
//                                                                            //
// Installs menu-items:                    Hotkey (advice)                    //
//    Session / Execute current statement  CTRL-ENTER                         //
//                                                                            //
// Thanks to:                                                                 //
//    Alex Nuijten for the idea and testing                                   //
//                                                                            //
// (c) 2008-2013: Patrick Barel                                               //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  v1.1   | PBA | Theo found a bug when the last semicolon is missing        //
//  v1.2   | PBA | Added a preference to keep the selection that is executed  //
//  v2.0   | PBA | Added toolbarbuttons                                       //
//         |     | Updated for PL/SQL Developer v10                           //
////////////////////////////////////////////////////////////////////////////////


[plsqldeveloper plugin]favorites
[v2.3]
Favorites plug-in.
Use this plug-in to keep your favorite files (scripts) handy all the time.


////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2005-2013: Bar Solutions                                         //
// patrick@bar-solutions.com                                                  //
// http://www.bar-solutions.com                                               //
// http://www.oracledeveloper.nl                                              //
////////////////////////////////////////////////////////////////////////////////
// Use this plug-in to keep favorite files available                          //
//                                                                            //
// Installs menu-items:                    Hotkey (advice)                    //
//    File / Favorite Files / Add Current                                     //
//    File / Favorite Files / Configure...                                    //
//                                                                            //
// Thanks to:                                                                 //
//  Testers:                                                                  //
//  Theo Tol                                                                  //
//  Erik van Roon                                                             //
//  Henk Jan van Wijk                                                         //
//  Marcel Hoefs                                                              //
//                                                                            //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  v1.1   | PBA | Added save position and size of config window              //
//         |     | Added posibility to add favorites menu to mainmenu         //
//         |     | Added posibility to show/hide path from menu               //
//         |     | Added posibility to choose your own menuname               //
//  v1.2   | PBA | Added button in config screen to load contents of a folder //
//  v1.3   | PBA | Added posibility to add seperators                         //
//         |     | Added button to select individual files                    //
//  v2.1   | PBA | Now checks if the file is already open, if so, it          //
//         |     | opens the window                                           //
//  v2.2   | PBA | Updated for PL/SQL Developer v10                           //
//  v2.3   | PBA | Added functionality to add custom toolbarbuttons           //
////////////////////////////////////////////////////////////////////////////////


[plsqldeveloper plugin]initcaps
[v2.2]
Init Caps plug-in.
Use this plug-in to change your selected text to Init Caps.
////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2006-2013: Bar Solutions                                         //
// patrick@bar-solutions.com                                                  //
// http://bar-solutions.com                                                   //
// http://blog.bar-solutions.com                                              //
////////////////////////////////////////////////////////////////////////////////
// Change the current selection to Init Caps                                  //
//                                                                            //
// Installs menu-items:                    Hotkey (advice)                    //
//    Edit / Selection / InitCaps             CTRL+Shift+I                    //
//                                                                            //
// Thanks to:                                                                 //
//  Theo Tol for testing this plug-in.                                        //
//                                                                            //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  v2.0   | PBA | New implementation to use common code in all plugins       //
//  v2.1   | PBA | Added a toolbar button                                     //
//         |     | Added support for beginning of line items                  //
//  v2.2   | PBA | Updated for PL/SQL Developer v10                           //
////////////////////////////////////////////////////////////////////////////////


[plsqldeveloper plugin]reconnect
[v2.1]
Reconnect plug-in.
Use this plug-in to reconnect to the database you were last connected to. For instance after a nigthly shutdown of the database.
////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2005-2013 Patrick Barel                                          //
// patrick@bar-solutions.com                                                  //
// http://blog.bar-solutions.com                                              //
// http://bar-solutions.com                                                   //
////////////////////////////////////////////////////////////////////////////////
// Use this plug-in to reconnect to the database you were last connected to   //
//                                                                            //
// Installs menu-items:                    Hotkey (advice)                    //
//    Session / Reconnect                                                     //
//                                                                            //
// Can create a toolbar button                                                //
//                                                                            //
// Thanks to:                                                                 //
//  BWendling for the idea posted on the PL/SQL Developer forum               //
//                                                                            //
// (c) 2005-2013: Patrick Barel / Bar Solutions                               //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  v2.0   | PBA | New implementation to use common code in all plugins       //
//  v2.1   | PBA | Updated for PL/SQL Developer v10                           //
////////////////////////////////////////////////////////////////////////////////


[plsqldeveloper plugin]save separate
[v2.1]
Save separate plug-in.
Use this plug-in to save the spec and body of a package in separate files.
////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2003-2013 Patrick Barel                                          //
// patrick@bar-solutions.com                                                  //
// http://blog.bar-solutions.com                                              //
// http://bar-solutions.com                                                   //
////////////////////////////////////////////////////////////////////////////////
// Use this plug-in to save the spec and body of a package in separate files  //
// Or to load the spec and body of a package from separate files              //
//                                                                            //
// Installs menu-items:                    Hotkey (advice)                    //
//    File / Save Separate                                                    //
//    File / Save Separate As...                                              //
//    File / Save Separate Settings                                           //
//                                                                            //
// (c) 2003-2013: Patrick Barel                                               //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  v1.1   | PBA | Added Load Separate functionality as requested by:         //
//         |     | Thomas Tanneberger (Thomas.Tanneberger@FINKundPARTNER.de)  //
//  v1.2   | PBA | Added Save Separate As... functionality as requested by:   //
//         |     | Andrew Lacwik (AndrewL@cpas.com)                           //
//  v2.0   | PBA | New implementation                                         //
//         |     | Disabled the Load Separate option as this is raising lots  //
//         |     | of issues for different people.                            //
//  v2.1   | PBA | Added option to change characterset                        //
//         |     | * ANSI                                                     //
//         |     | * UTF8                                                     //
//         |     | * UTF8BOM                                                  //
//         |     | Seán Garvan (garvansean@gmail.com)                         //
//         |     | Added toolbarbuttons                                       //
//         |     | Updated for PL/SQL Developer v10                           //
////////////////////////////////////////////////////////////////////////////////
// The location of the files can be configured in the configure plug-ins      //
// dialog of PL/SQL Developer.                                                //
////////////////////////////////////////////////////////////////////////////////


[plsqldeveloper plugin]template
[v2.7]
Template plug-in.
Use this plug-in to use templates like the way the Delphi IDE works.
////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2003-2009: Bar Solutions                                         //
// patrick@bar-solutions.com                                                  //
// http://blog.bar-solutions.com                                              //
// http://bar-solutions.com                                                   //
// http://www.oracledeveloper.nl                                              //
////////////////////////////////////////////////////////////////////////////////
// Use this plug-in to create and use templates                               //
//                                                                            //
// Installs menu-items:                    Hotkey (advice)                    //
//    Edit / Template / Replace            CTRL+J                             //
//    Edit / Template / Setup              CTRL+ALT+J                         //
//                                                                            //
// Thanks to:                                                                 //
//  Theo Tol for testing this plug-in.                                        //
//  Richard Brooker for some good suggestions and for finding some bugs       //
//  Jason Vogel for pointing out the compatibility with the standard snippets //
//  Alex Nuijten for handing me some ideas                                    //
//  Marc Nolte for the German date formats                                    //
//                                                                            //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  v1.1   | PBA | Changed behaviour to be more like the Delphi IDE           //
//  v1.2   | PBA | Added support to position the cursor in the template using //
//         |     | the '|' character                                          //
//  v1.3   | PBA | Now takes indenting into account                           //
//  v1.4   | PBA | Now also looks at the plug-in directory from the           //
//         |     | preferences window to find the templates.ini file          //
//  v1.5   | PBA | Double | characters for concatenating in Oracle are now    //
//         |     | supported                                                  //
//  v1.6   | PBA | Window position and size is remembered                     //
//         |     | The grid columns size automatically to the width of the    //
//         |     | grid control.                                              //
//  v1.7   | PBA | Added support for [#] to position the cursor.              //
//         |     |     The order for positioning the cursor is:               //
//         |     |     The first occurrence of [#]                            //
//         |     |     The first occurrence of |                              //
//         |     |     The first occurrence of ||                             //
//         |     | Added a little help part to the setup window.              //
//         |     | Items in the setup window are now sorted by name.          //
//  v2.0   | PBA | New implementation to use common code in all plugins       //
//  v2.1   | PBA | Now also possible to use the template functionality when   //
//         |     | not at the end of the template (Thanks Alex)               //
//  v2.2   | PBA | Added support for $OSUSER, $DBUSER, $DATE, $TIME           //
//         |     | in the templates                                           //
//  v2.3   | PBA | Set position correctly                                     //
//  v2.4   | PBA | Added hash value to templates to implement case sensitivity//
//  v2.5   | PBA | Added date and time formatting                             //
//  v2.6   | PBA | Added more date formats                                    //
//  v2.7   | PBA | Updated for PL/SQL Developer v10                           //
////////////////////////////////////////////////////////////////////////////////


For version 2.4 and up a new ini file format is used. If you installed an older version, please use the ini file converter.
Click here to download ConvertTemplateIni.zip

[plsqldeveloper plugin]toggle read-only
[v2.0]
Toggle Read-Only plug-in.
Use this plug-in to toggle the read-only state of your window.
////////////////////////////////////////////////////////////////////////////////
// PL/SQL Developer Plug-In                                                   //
// Copyright 2003-2013 Patrick Barel                                          //
// patrick@bar-solutions.com                                                  //
// http://bar-solutions.com                                                   //
// http://blog.bar-solutions.com                                              //
////////////////////////////////////////////////////////////////////////////////
// Use this plug-in to toggle the read-only state of a window.                //
//                                                                            //
// Installs menu-items:                    Hotkey (advice)                    //
//    Edit / Toggle Read-Only              SHIFT+CTRL+R                       //
//                                                                            //
//                                                                            //
// (c) 2003-2013: Patrick Barel                                               //
////////////////////////////////////////////////////////////////////////////////
// Revision History:                                                          //
// Version | Who | What                                                       //
//  v1.0   | PBA | Initial version...                                         //
//  v2.0   | PBA | Added toolbar button                                       //
//         |     | Updated for PL/SQL Developer v10                           //
////////////////////////////////////////////////////////////////////////////////