A script-enabled browser is required for this page to function properly.

The Syntax Palette Interface

The Syntax Palette enables you to display the constructs of PL/SQL language elements and Built-in packages, and allows you to copy selected syntax into the Program Unit editor or Stored Program Unit editor.

The Syntax Palette has the following components:

PL/SQL page
Allows you to display and select a PL/SQL language element for copying. The PL/SQL language elements are grouped by categories such as Control Flow, Cursors, Exceptions and so on.
 
Built-ins page
Allows you to display and select a PL/SQL construct (function or procedure) from a Built-in package for copying.
 
Drop-down list

Displays a PL/SQL category name or a Built-in package name.

Click the arrow on the right to choose a PL/SQL category or Built-in package.

List area

Displays the individual language elements in a selected PL/SQL category or the constructs in a selected Built-in package. The first item in the list is highlighted (selected) by default.

Click a language element or construct to select it and to show its full syntax in the display area.

Double-clicking an item inserts the syntax of the PL/SQL language element or construct into the active editor window at the current cursor position.

Display area
Shows the full syntax of a selected PL/SQL language element or construct.
 
Insert
Click to copy the selected item in the list area to the current cursor position in the active editor window.
 
Close
Click to close the Syntax Palette.
 
Help
Displays this help topic.