Structured Query Language

SQL Tutorial & Tips Select Insert Update Delete Open Cursor Fetch Close Cursor Union

                  Close Cursor





 
Closes an open cursor. CLOSE leaves the data structures accessible
for reopening; however, modifications or fetches are not allowed
until the cursor is reopened.
 
Syntax:
 
CLOSE cursor_name
 
where
  cursor_name
Specifies the name of an already-declared cursor.