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. |
Inserting syntax into the PL/SQL Editor
Copyright © 1984, 2005, Oracle. All rights reserved.