|The syntax diagram changes to:
|>>-+---------------------------------------+--fullselect--------> | | .-,--------------------------. | | | V | | | '-WITH-----common-table-expression---+--' | |>----+-----------------+--+--------------------+----------------> | '-order-by-clause-' '-fetch-first-clause-' | |>----*--+---------------------+--*--+---------------------+--*--> | +-read-only-clause----+ '-optimize-for-clause-' | | (1) | | '-update-clause-------' | |>-----+---------------+---------------------------------------->< | '-WITH--+-RR-+--' | +-RS-+ | +-CS-+ | '-UR-' |
|Note:
|Add the following paragraph to the description below the syntax diagram:
|
The optional WITH clause specifies the isolation level at which the select |statement is executed. | |
|The default isolation level of the statement is the isolation level |of the package in which the statement is bound. |
The last paragraph in the description of the fetch-first-clause:
Specification of the fetch-first-clause in a select-statement makes the cursor not deletable (read-only). This clause cannot be specified with the FOR UPDATE clause.
is incorrect and should be removed.