如何优化游标--使用只读游标

标准游标

declare my_cursor cursor

for

select * from s_yhb

只读游标

declare my_cursor cursor

for

select * from s_yhb

for read only

更新游标

declare my_cursor cursor

for

select * from s_yhb

for update