Hi, welcome to Toby's PL/SQL Editor Home Page.
This contains information concerning Toby's PL/SQL Editor, including information such as:
Details about the developers. (Eventually)
What is the PL/SQL Editor?
The PL/SQL editor is a plugin for the eclipse integrated development environment that allows you to more easily develop and test PL/SQL code.
You can download the plugin at sourceforge. The change log for the editor can be seen here.
If you want, you can also use the Eclipse Update capability by setting the update site to point to http://plsqleditor.sourceforge.net/updates.
Here is a basic user guide (still being developed - last updated 21 February 2006).
Here is a basic faq (still being developed).
The following is a list of features that this product either supports or will support (helpfully divided up into those two sections).
Features Already Supported
This is the list (possibly not exhaustive, but hopefully relatively close) of the existing features.
PL/SQL Syntax Colouring (with some colour choice available)
PL/SQL Code auto completion of other schema/package/procedure, schema/package/function, schema/package/constant within a file or database
Auto completion of built in PL/SQL functions (with documentation)
PL/SQL Code auto completion parameters within a given package's procedure or function in a file
PL/SQL Code auto completion of globally declared fields and types (within a package somewhere in the file or database)
PL/SQL Code auto completion of local variables within a given package's procedure or function in a file
Open declaration function (F3) which allows you to open the implementation of a function, procedure, field or type declared in a file somewhere
Navigate to parameter or local field in function (F3)
Generate PL/SQL Package Header from correctly documented body
Load a PL/SQL Package Header or Package Body to the database (Ctrl-Alt-L)
Execute a PL/SQL block into the database (Ctrl-Alt-E)
Pldoc documentation appears on hover
Code generation templates for FOR loops, IF blocks, CASE statements, SAVEPOINTS, FUNCTIONS and PROCEDURES
Uppercasing and Lowercasing selected text
Executing Sql and seeing the table output
Executing Sql and seeing the dbms output
Auto commenting and uncommenting blocks of code
Execution of plsql code into separate database instances
Code folding on user selected blocks
PL/SQL Code auto completion of tables within a given schema in the database
Schema Browser of schemas, packages/procedures/functions and tables/columns
Viewing grants on packages from the Schema Browser
Viewing database package source from the Schema Browser
TODO and FIXME tasks
Features Soon to be Supported
This is the list (definitely not exhaustive) of upcoming features.
Code auto formatting, with preferences (Ctrl-Shift-F)
Refactoring - renaming a field/variable/function/procedure/parameter
Refactoring - extracting a constant
Refactoring - extracting a function
Refactoring - extracting a procedure
Quick Fixes - extracting a constant
Quick Fixes - adding a local variable
Quick Fixes - adding a package global variable
Quick Fixes - adding a parameter
Ctrl-Shift-T : Opening package body files by package name (synonymous with Open Type in Java)
Automatic (and configurable) Code Folding on IF statements, loops, procedures and functions.