Statement Description
DECLARE Defines a new cursor.
OPEN Opens and populates the cursor by executing the SELECT statement defined by the cursor.
FETCH Retrieves a row from the cursor.
CLOSE Closes the cursor.
DEALLOCATE Deletes the cursor definition and releases all system resources associated with the cursor.