oracle中的ref游标概念 [英] ref cursor concepts in oracle

问题描述

1)基准光标是什么?
2)在SCENERIO中，我必须使用REF CURSOR.
3)游标和参考游标之间的差异.
4)REF游标将有一个性能问题.

1) WHT IS REF CURSOR ?
2) IN WHICH SCENERIO , I HAVE TO USE THE REF CURSOR .
3) DIFFERENCE BETWEEN CURSOR AND REF CURSOR.
4) WILL REF CURSOR HAVE A PERFORMANCE ISSUE.

推荐答案

这将解释ref游标-和普通游标之间的区别.
http://www.asktheoracle.net/what-is-ref-cursor.html [ ^ ]


http://www.devshed.com/c/a /Oracle/Working-with-REF-CURSOR-in-PL-SQL/ [ http://www.dba-oracle.com/t_pl_sql_ref_cursor_benefits.htm [

This one explains the ref cursor- and difference between normal cursor.
http://www.asktheoracle.net/what-is-ref-cursor.html[^]


http://www.devshed.com/c/a/Oracle/Working-with-REF-CURSOR-in-PL-SQL/[^]

Regarding your question on performance,
Advantage similar to normal reference var, for pass by reference stuffs
- this one says in detail about it
http://www.dba-oracle.com/t_pl_sql_ref_cursor_benefits.htm[^]


Hope this helps your need.

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