PL/SQL Developer - The PL/SQL Editor


The Unicode compliant PL/SQL Editor offers all features you expect from a modern development tool. It provides multi-level undo & redo, bookmarks, block indent & unindent, powerful find & replace with regular expressions, a macro recorder and library, column editing, split editing, and more.

The PL/SQL Editor also offers a wide range of assistance to the programmer. There is context sensitive help through Oracle's on-line HTML Manuals: just press F1 when the cursor is on a keyword to perform an indexed search in your personal selection of manuals.

Right-click on a database object and you will see a context sensitive Object Popup Menu. From this popup menu you can view the properties or a description of the object. If the object is a program unit, you can view or edit the source. If it is a table or view, you can query or edit the data.

The Code Assistant automatically provides information about database objects and PL/SQL syntax elements as you type their name. In the screenshot above you can see that all columns of the emp table are displayed when the cursor is located after the "." of the table name. You can now select a column name, or continue typing to filter the column list. The Code Assistant will provide a parameter list for functions and procedures, will display a list of all elements of packages, will display a column list for tables, views, cursors and rowtypes, will display a field list for record types, will display all objects owned by a user, and will autocomplete SQL and PL/SQL syntax elements, variables, parameters and object names.

With the Special Paste and Copy From Host Language functions you can quickly convert your source code between a host language like C++ or Java and Oracle PL/SQL.

Compiler Hints will help you increase the quality of your code, and can help you find errors that you would normally only find at run-time. You will receive hints about unused declarations (e.g. a local variable that is not used), unused value assignments, comparisons with NULL, functions without a return statement, implicit date conversions, and violations of user-defined naming conventions for objects, variables, parameters, and so on.

Highlighting will automatically mark code structures (if/then/else, case, loops, and so on) and variable/parameter names when the cursor is placed on it. This makes it easier to see the structure of the code, and can provide insight into the impact of a change.

The Refactoring function can assist you when reorganizing your code. It can extract a selection of code as a separate procedure, rename variables and parameters, extract constants, and so on.

The PL/SQL Beautifier allows you to format your PL/SQL code through a user-defined set of rules. Your code can automatically be beautified when you compile, save, or open a file.

The Code Contents shows all functions, procedures, variables, constants, types, parameters, and exceptions defined in a program unit, and allows you to zoom into the structure of a program unit. This is most useful in large package or type bodies, which can contain thousands of lines of code. You can quickly navigate through such a source file by clicking on an element in the Code Contents. The Code Hierarchy above the editor will additionally show you where you are located in the program hierarchy.

The Code Folding functionality allows you to show or hide specific sections of PL/SQL code. You could for example fold all procedures and functions within a package, and unfold just the one that you are interested in. As another example you can fold structures like loops and if/then/else statements to get a better overview within a long program unit.

Hyperlink Navigation allows you to quickly find an object declaration. Press the Control key and click on an object name in the editor, and you will navigate to its declaration. This can be a variable, a parameter, a type, a function or procedure call, a view, an exception, and so on.

With the Compare To function you can quickly compare the contents of the editor to the source of a database object or to the contents of a file.

The Web Search function allows you to quickly find source code references on the Web. You can use the pre-defined Web Searches and define your own.

The PL/SQL Editor can also be used to edit Java Source code in an Oracle database.