关于Oracle中的游标 [英] About Cursor in Oracle

问题描述

嗨
谁能解释我在oracle中ref游标和简单游标之间的区别
有适当的例子.




预先感谢您，

Shilpi

Hi
Can anyone explain me difference between ref cursor and simple cursor in oracle
with proper example.




Thanking you in advance,

Shilpi

推荐答案

REF游标是一种动态游标，支持在运行时更改查询.通常，REF游标用于返回记录集或存储过程中的游标.
如
普通游标是静态游标，在该游标中，查询是在设计时分配的，不能在运行时更改.

参考:
MSDN:使用Oracle REF CURSOR [ Oracle/PLSQL主题:游标 [

REF cursor is a dynamic cursor that supports change of query at runtime. Typically, REF cursor is used to return a record set or a cursor from stored procedure.
where as
Normal cursor is a static cursor where the query is assigned at design time and it can not be changed at runtime.

Refer:
MSDN: Working with Oracle REF CURSORs[^]
Oracle/PLSQL Topics: Cursors[^]

这篇关于关于Oracle中的游标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！