Explanation

KEYWORDS

Keywords are shown in uppercase letters for the sake of clarity. They can be entered in uppercase or lowercase letters.

<xyz>

Terms in angle brackets are placeholders for syntactical units explained in this document. Do not use angle brackets when entering an SQL statement.

<!  Text  !>

Texts enclosed in angled brackets and exclamation points indicate that the syntactical unit is explained by means of a text. Do not use angled brackets and exclamation points when entering an SQL statement.

clause ::= rule

Clauses are the building blocks of SQL statements. Rules describe how these building blocks are put together to form more complex clauses and also dictate the notation that is used.

clause₁ clause₂

The two clauses are written one after the other, separated by at least one blank.

[clause]

Optional clause. This clause can be ignored. Do not use square brackets when entering an SQL statement.

Clause1 | clause2 | ... | clause_n

Alternative clauses. You can use exactly one of these clauses.

Clause,...

The clause can be repeated as often as required. The individual repetitions must be written one after the other and separated by a comma and any number of blanks.

Clause ...

The clause can be repeated as often as required. The individual repetitions must be written one after the other and separated by spaces.

Clause...

The clause can be repeated as often as required. The individual repetitions are to be recorded in direct sequence.