Sequence of data manipulations using a cursor
Cursor SQL statements are as follows:
· Cursor declaration (DECLARE CURSOR)
· OPEN statement
· CLOSE statement
· FETCH statement
· UPDATE statement
· DELETE statement
The SQL statement used to declare a cursor is the cursor declaration, a non-executable statement. The cursor
41