redhat man page for move

Query: move

OS: redhat

Section: 7

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

MOVE(7) 							   SQL Commands 							   MOVE(7)

NAME
MOVE - position a cursor on a specified row of a table
SYNOPSIS
MOVE [ direction ] [ count ] { IN | FROM } cursor
DESCRIPTION
MOVE allows a user to move cursor position a specified number of rows. MOVE works like the FETCH command, but only positions the cursor and does not return rows. Refer to FETCH [fetch(7)] for details on syntax and usage. NOTES MOVE is a PostgreSQL language extension. Refer to FETCH [fetch(7)] for a description of valid arguments. Refer to DECLARE [declare(7)] to define a cursor. Refer to BEGIN [begin(7)], COMMIT [commit(7)], and ROLLBACK [rollback(7)] for further information about transactions.
USAGE
Set up and use a cursor: BEGIN WORK; DECLARE liahona CURSOR FOR SELECT * FROM films; -- Skip first 5 rows: MOVE FORWARD 5 IN liahona; MOVE -- Fetch 6th row in the cursor liahona: FETCH 1 IN liahona; FETCH 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 commit work: CLOSE liahona; COMMIT WORK;
COMPATIBILITY
SQL92 There is no SQL92 MOVE statement. Instead, SQL92 allows one to FETCH rows from an absolute cursor position, implicitly moving the cursor to the correct position. SQL - Language Statements 2002-11-22 MOVE(7)
Related Man Pages
declare(7) - redhat
fetch(7) - redhat
move(7) - suse
rollback_to_savepoint(7) - suse
rollback_to_savepoint(7) - netbsd
Similar Topics in the Unix Linux Community
Command to know the terminal cursor position
cursor positioning
Help with the idea of a script to modify time
Replace a string within a file.. with help of positions
Getting the cursor position