## 移动

MOVE — 定位光标

## 概要

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

## 描述

`移动`重新定位游标而不检索任何数据。`移动`工作原理完全一样`拿来`命令，除了它只定位光标并且不返回行。

的参数`移动`命令是相同的`拿来`命令;参考[拿来](sql-fetch.html)有关语法和用法的详细信息。

## 输出

成功完成后，一个`移动`命令返回形式的命令标签

```
MOVE count
```

这*`数数`*是 a 的行数`拿来`具有相同参数的命令将返回（可能为零）。

## 例子

```
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
## Compatibility

 There is no `MOVE` statement in the SQL standard.

## See Also

[CLOSE](sql-close.html), [DECLARE](sql-declare.html), [FETCH](sql-fetch.html)
```