循环游标
FOR record_index IN cursor_name
LOOP
executable_statements
END LOOP;
普通游标
CURSOR cursor_name [(parameter [, parameter]...)]
[RETURN return_type] IS select_statements;
OPEN cursor_name [(parameters)];
FETCH cursor_name INTO variables;
CLOSE cursor_name;
可更新的游标
CURSOR cursor_name IS
select_statement FOR UPDATE [OF columns];
UPDATE table_name
SET column_name=column_value
WHERE CURRENT OF cursor_name;