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

Inserting syntax into the PL/SQL Editor

To copy syntax into the PL/SQL Editor:

  1. Make sure the PL/SQL Editor or Stored PL/SQL Editor is the current (most recently selected) window.

  2. Place the cursor in the editor where you want to insert the syntax, then choose Toolsright arrowSyntax Palette.

  3. In the Syntax Palette, click the PL/SQL tab or the Built-ins tab.

  4. Choose a PL/SQL category or a built-in package from the list.

When you click a category or a package, the PL/SQL language elements or PL/SQL constructs that are available for selection appear in the list area below.

  1. Choose a PL/SQL language element or construct in the list area.

When you click a PL/SQL language element or construct, the syntax appears in the display area that is below the list area.

  1. Click Insert to copy the selected syntax.

The selected PL/SQL language element or construct is inserted into the active editor at the current cursor position.

  1. Replace all lowercase items that are not comments with the appropriate values. Items within comments are optional. Reserved words are in uppercase.

Note: You can also double-click a PL/SQL language element or construct in the list area to insert the syntax into an editor.

See also

About program units

About stored program units