declare cursor_name cursor
for select column_name from table_name
for update/delete column_name_list(显示定义为更新或删除,建议这样定义)
open cursor_name
fetch cursor_name
close cursor_name
deallocate cursor cursor_name(释放游标)
declare cursor_name cursor
for select column_name from table_name
for update/delete column_name_list(显示定义为更新或删除,建议这样定义)
open cursor_name
fetch cursor_name
close cursor_name
deallocate cursor cursor_name(释放游标)