In embedded SQL, statements that retrieve data and statements that update data can both involve cursors.
The retrieval statements that involve cursors are:
DECLARE cursor_name CURSOR FOR . . .
OPEN cursor_name
FETCH cursor_name INTO . . .
CLOSE cursor_name
The update statements that involve cursors are:
UPDATE . . . WHERE CURRENT OF cursor_name
DELETE . . . WHERE CURRENT OF cursor_name