1.1.4 Insertion of delimiters

The following characters can be used as delimiters:

Organization of this subsection
(1) Delimiter insertion locations
(2) Locations where a delimiter is not allowed
(3) Locations where a delimiter is allowed
(4) Comment

(1) Delimiter insertion locations

A delimiter can be inserted at the following locations:

The following figure shows examples of inserting delimiters.

Figure 1-1 Examples of delimiter insertion

[Figure]

(2) Locations where a delimiter is not allowed

A delimiter cannot be inserted in any of the following locations:

The following figure shows examples of locations where delimiters are not allowed.

Figure 1-2 Examples of locations where delimiter is not allowed

[Figure]

(3) Locations where a delimiter is allowed

Delimiters can be inserted in the following locations:

The following figure shows examples of locations where delimiters can be inserted.

Figure 1-3 Examples of locations where delimiter can be inserted

[Figure]

(4) Comment

In an SQL statement, any characters that appear after a /* and before the first */ that is encountered are treated as a comment. When inserting a comment, observe the following notes:

Examples of specifying a comment are given as follows:

Correct examples:

CREATE TABLE T1(C1 INT) /* COMMENT */

CREATE /* COMMENT */ TABLE T1(C1 INT)

Incorrect examples:

SELECT * FROM T1 /* COMMENT
... An error occurs due to the absence of a */ termination symbol.

CREATE TABLE T1 /* COMMENT1 /* COMMENT2 */ COMMENT3 */(C1 INT)
... Nested comments cause an error.