MOVE

MOVE —定位光标

Synopsis

MOVE [ direction [ FROM | IN ] ] cursor_name

where direction can be empty or one of:

    NEXT
    PRIOR
    FIRST
    LAST
    ABSOLUTE count
    RELATIVE count
    count
    ALL
    FORWARD
    FORWARD count
    FORWARD ALL
    BACKWARD
    BACKWARD count
    BACKWARD ALL

Description

MOVE重新定位光标而未获取任何数据。 MOVE的工作方式与FETCH命令完全相同，只不过它仅定位光标而不返回行。

MOVE命令的参数与FETCH命令的参数相同。有关语法和用法的详细信息，请参阅FETCH。

Outputs

成功完成后，MOVE命令将返回以下形式的命令标签：

MOVE count

• count *是具有相同参数的FETCH命令返回的行数(可能为零)。

Examples

BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;

-- Skip the first 5 rows:
MOVE FORWARD 5 IN liahona;
MOVE 5

-- Fetch the 6th row from the cursor liahona:
FETCH 1 FROM liahona;
 code  | title  | did | date_prod  |  kind  |  len
-------+--------+-----+------------+--------+-------
 P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
(1 row)

-- Close the cursor liahona and end the transaction:
CLOSE liahona;
COMMIT WORK;

Compatibility

SQL 标准中没有MOVE语句。

See Also

CLOSE, DECLARE, FETCH