**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]
Sidebar
fetch
FETCH Statement - PL/HQL Reference
FETCH statement retrieve the next row from a cursor and assigns column values to local variable.
Syntax:
FETCH [FROM] cursor_name INTO var1 [, var2, ...];
Parameters:
| Parameter | Type | Value | Description |
| cursor_name | Identifier | The name of the previously opened cursor | |
| varN | Variable | A local variable |
Examples:
DECLARE tabname VARCHAR DEFAULT 'db.orders'; DECLARE id INT; DECLARE cur CURSOR FOR 'SELECT id FROM ' || tabname; OPEN cur; FETCH cur INTO id; WHILE SQLCODE=0 THEN PRINT id; FETCH cur INTO id; END WHILE; CLOSE cur;
Compatibility: Oracle, IBM DB2, Teradata, SQL Server, MySQL, PostgreSQL and Netezza.
See also:
Page Tools
