Oracle游标应用示例
Oracle游标使用示例declareRoomID Room.RoomID%TypeRoomName Room.RoomName%Typecursor crRoom isselect
Oracle游标使用示例
declare RoomID Room.RoomID%Type; RoomName Room.RoomName%Type; cursor crRoom is select RoomID,RoomName from Room; begin open crRoom;loop（这里不要加分号）fetch crRoom into RoomID,RoomName; exit when crRoom%notFound; end loop; close crRoom; end;
2.游标返回：
begin open rt_cursor for select * from dual; end;
??
