Query: move
OS: suse
Section: 7
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
MOVE(7) SQL Commands MOVE(7)NAMEMOVE - position a cursorSYNOPSISMOVE [ direction { FROM | IN } ] cursornameDESCRIPTIONMOVE repositions a cursor without retrieving any data. MOVE works exactly like the FETCH command, except it only positions the cursor and does not return rows. The parameters for the MOVE command are identical to those of the FETCH command; refer to FETCH [fetch(7)] for details on syntax and usage.OUTPUTSOn successful completion, a MOVE command returns a command tag of the form MOVE count The count is the number of rows that a FETCH command with the same parameters would have returned (possibly zero).EXAMPLESBEGIN 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;COMPATIBILITYThere is no MOVE statement in the SQL standard.SEE ALSOCLOSE [close(7)], DECLARE [declare(7)], FETCH [fetch(7)] SQL - Language Statements 2010-05-14 MOVE(7)
Related Man Pages |
---|
move(7) - centos |
close(7) - suse |
declare(7) - suse |
rollback_to_savepoint(7) - suse |
declare(7) - posix |
Similar Topics in the Unix Linux Community |
---|
How to reach to the end of the file? |
SQL Commands in Unix |
to get two almost identical rows into one |
Fetch data from a particular location |
SQL*PLUS How to display a count of 0 |