Oracle游标使用示例

1.游标处理：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;