Managing a cursor is similar to managing a file in a programming language. The following steps manage cursors:
Declare a cursor for a particular SELECT statement or procedure using the DECLARE statement.
Open the cursor using the OPEN statement.
Use the FETCH statement to retrieve results one row at a time from the cursor.
A row not found warning signals the end of the result set.
Close the cursor using the CLOSE statement.
By default, cursors are automatically closed at the end of a transaction (on COMMIT or ROLLBACK statements). Cursors opened using the WITH HOLD clause stay open for subsequent transactions until explicitly closed.