All pages
Powered by GitBook
1 of 1

Loading...

OPEN

Syntax

OPEN cursor_name [expression[,...]];
OPEN cursor_name

Description

This statement opens a which was previously declared with .

The query associated to the DECLARE CURSOR is executed when OPEN is executed. It is important to remember this if the query produces an error, or calls functions which have side effects.

This is necessary in order to rows from a cursor.

See for an example.

See Also

This page is licensed: GPLv2, originally from

cursor
DECLARE CURSOR
FETCH
Cursor Overview
Cursor Overview
DECLARE CURSOR
FETCH cursor_name
CLOSE cursor_name
fill_help_tables.sql
Cursors in Oracle mode