Unix/Linux Go Back    

RedHat 9 (Linux i386) - man page for move (redhat section 7)

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)

MOVE(7) 				   SQL Commands 				  MOVE(7)

       MOVE - position a cursor on a specified row of a table

       MOVE [ direction ] [ count ]
	   { IN | FROM } cursor

       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.

       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 ROLL-
       BACK [rollback(7)] for further information about transactions.

       Set up and use a cursor:

       BEGIN WORK;
       DECLARE liahona CURSOR  FOR SELECT * FROM films;
       -- Skip first 5 rows:
       MOVE FORWARD 5 IN liahona;
       -- Fetch 6th row in the cursor liahona:
       FETCH 1 IN 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 commit work:
       CLOSE liahona;

       There is no SQL92 MOVE statement.  Instead, SQL92 allows one to FETCH rows from	an  abso-
       lute cursor position, implicitly moving the cursor to the correct position.

SQL - Language Statements		    2002-11-22					  MOVE(7)
Unix & Linux Commands & Man Pages : ©2000 - 2018 Unix and Linux Forums

All times are GMT -4. The time now is 10:22 AM.