E
Syntax Diagram Conventions

This document discusses the syntax diagrams used in the Oracle Lite SQL Reference. Topics include:

E.1 Introduction

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.

E.2 Required Keywords and Parameters

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:

Figure E-1 Syntax for Required Keywords and Parameters

According to the diagram, the following syntax is valid:

CREATE USER hannibal IDENTIFIED BY hanna;

In the following diagram, either DELETE, SELECT, or UPDATE is a required parameter:

Figure E-2 Syntax for Required Parameters

E.3 Optional Keywords and Parameters

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:

Figure E-3 Syntax for Required Optional Keywords and Parameters

According to the diagram, all of the following statements are valid:

ROLLBACK WORK;
ROLLBACK TO savepoint_1;
ROLLBACK;

E.4 Syntax Loops

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.

Figure E-4 A Syntax Loop

E.5 Multipart Diagrams

Read a multipart diagram as if all the main paths were joined end to end. The following example is a two-part diagram:

Figure E-5 Syntax for a Multipart 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;

E.6 Database Objects

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.

E Syntax Diagram Conventions