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

Syntax Palette

The Syntax Palette is a programming tool that enables you to display and copy the constructs of PL/SQL language elements and built-in packages into the PL/SQL Editor and Stored PL/SQL Editor.

The Syntax Palette contains:

PL/SQL tab page

Enables you to display and select PL/SQL language elements for copying. The PL/SQL language elements are grouped by categories such as Control Flow, Cursors, Exceptions, and so on.

Built-ins page

Enables you to display and select built-in PL/SQL constructs (functions or procedures) for copying. The built-ins are grouped by package names such as EXEC_SQL, DEBUG, DDE, and so on.

 

Each tab page contains:

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.

Display area

Shows the full syntax of a selected PL/SQL language element or construct. Reserved words are in uppercase items.

After inserting the syntax into the editor, replace lowercase items that are not within comments with the appropriate values. Lowercase items within comments are optional.

Insert

Click to copy the selected item in the list area to the current cursor position in the active editor window.

See also

Inserting syntax into the PL/SQL Editor