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

Inserting Syntax into an Editor

To copy syntax into an editor:

  1. Make sure the Program Unit editor or Stored Program Unit editor is the current (most recently selected) window.
  2. Place the cursor in the editor where you want to insert the syntax.
  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 drop-down 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.
  5. 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.
  6. 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.
  7. Replace all lowercase items that are not comments with the appropriate values. Items within comments are optional. Reserved words are in uppercase.