云数据库 GAUSSDB-FETCH:语法格式

时间:2024-11-02 18:48:30

语法格式

FETCH [ direction { FROM | IN } ] cursor_name;

其中direction子句为可选参数。

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
NEXT
   | PRIOR
   | FIRST
   | LAST
   | ABSOLUTE count
   | RELATIVE count
   | count
   | ALL
   | FORWARD
   | FORWARD count
   | FORWARD ALL
   | BACKWARD
   | BACKWARD count
   | BACKWARD ALL
support.huaweicloud.com/distributed-devg-v2-gaussdb/gaussdb_v5r2c10_0582.html