关于Oracle中的游标 [英] About Cursor in Oracle
本文介绍了关于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屋!
查看全文