User Tools

Site Tools


Sidebar

**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]]

close

====== CLOSE Statement - PL/HQL Reference ====== CLOSE statement closes a cursor. **Syntax**: <code language=sql> CLOSE cursor_name; </code> **Parameters:** | **Parameter** | **Type** | **Value** | **Description** | | cursor_name | | Identifier | The name of the previously opened cursor | **Examples:** <code language=sql> DECLARE id INT; DECLARE cur CURSOR FOR 'SELECT id FROM db.orders'; OPEN cur; FETCH cur INTO id; CLOSE cur; </code> **Compatibility:** Oracle, IBM DB2, Teradata, SQL Server, PostgreSQL, MySQL. **See also:** * [[declare-cursor|DECLARE CURSOR]] * [[open|OPEN]] * [[fetch|FETCH]] * [[sqlcode|SQLCODE]]