Oracle游标的三种用法

循环游标
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;