版次注意事項


38.4 Chapter 5. Queries

|38.4.1 select-statement/syntax diagram

|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:

  1. |The update-clause and the order-by-clause cannot both be specified |in the same select-statement. |

|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. |

38.4.2 select-statement/fetch-first-clause

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.


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]