Hi, welcome to Toby's PL/SQL Editor Home Page.
This contains information concerning Toby's PL/SQL Editor, including information such as:

• What the PL/SQL editor is all about

• Where you can download it

• A User Guide

• A list of upcoming features.

• Documentation of known bugs and workarounds.

• 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.

Download
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.

User Guide
Here is a basic user guide (still being developed - last updated 21 February 2006).

FAQ
Here is a basic faq (still being developed).

Features
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.