This document discusses the syntax diagrams used in the Oracle Database 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 Figure F-1, user and password are required parameters:
BNF Notation
CREATE USER user IDENTIFIED BY password;
According to the diagram, the following syntax is valid:
CREATE USER hannibal IDENTIFIED BY hanna;
In Figure F-2, either DELETE, SELECT, or UPDATE is a required parameter:
BNF Notation
{ DELETE | SELECT | UPDATE } //hint// ;
If keywords and parameters appear in a vertical list above the main path, they are optional. In Figure F-3, you can choose from the vertical list of options or you can continue along the main path:
BNF Notation
ROLLBACK [{ WORK | TO savepoint_name }] ;
According to the diagram, all of the following statements are valid:
ROLLBACK WORK; ROLLBACK TO savepoint_1; ROLLBACK;
Loops enable you to repeat the syntax within them as many times as you like. In Figure F-4, after choosing one expression, you can go back repeatedly to choose another, separated by commas.
BNF Notation
[ expr [, expr]...]
Read a multipart diagram as if all the main paths were joined end to end. The example in Figure F-5 is a two-part diagram:
BNF Notation
CREATE [PUBLIC] SYNONYM [schema ] synonym FOR [schema ] object ;
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.
The syntax diagrams in this document use a variation of Backus-Nauer Form (BNF) notation. For a description of the convention used in this document, please see Section 4.2.6, "BNF Notation Conventions".