|Oracle9i Lite SQL Reference
Part Number A90108-01
This document discusses the syntax diagrams used in the Oracle Lite SQL Reference. Topics include:
Syntax diagrams are drawings that illustrate valid SQL syntax. To read a diagram, trace it from left to right, in the direction shown by the arrows.
Commands and other keywords appear in UPPERCASE inside rectangles. Type them exactly as shown in the rectangles. Parameters appear in lowercase inside ovals. Variables are used for the parameters. Punctuation, operators, delimiters, and terminators appear inside circles.
If the syntax diagram has more than one path, you can choose any path to travel.
If you have the choice of more than one keyword, operator, or parameter, your options appear in a vertical list.
Required keywords and parameters can appear singly or in a vertical list of alternatives. Single required keywords and parameters appear on the main path, that is, on the horizontal line you are currently traveling. In the following diagram, user and password are required parameters:
According to the diagram, the following syntax is valid:
In the following diagram, either DELETE, SELECT, or UPDATE is a required parameter:
If keywords and parameters appear in a vertical list above the main path, they are optional. In the following example, you can choose from the vertical list of options or you can continue along the main path:
According to the diagram, all of the following statements are valid:
Loops enable you to repeat the syntax within them as many times as you like. In the following example, after choosing one expression, you can go back repeatedly to choose another, separated by commas.
Read a multipart diagram as if all the main paths were joined end to end. The following example is a two-part diagram:
According to the diagram, the following statements are valid:
CREATE SYNONYM prod FOR product; CREATE SYNONYM prod FOR scott.product; CREATE SYNONYM scott.prod FOR scott.product;
The names of Oracle Lite identifiers, such as tables and columns, must not exceed 30 characters in length. The first character must be a letter, but the rest can be any combination of letters, numerals, dollar signs ($), pound signs (#), and underscores (_).
However, if an Oracle Lite identifier is enclosed by double quotation marks ("), it can contain any combination of legal characters, including spaces but excluding quotation marks. Oracle Lite identifiers are not case-sensitive except when enclosed by double quotation marks.