Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

performance Tuning 10g reference poster
 
Oracle training in Linux 

commands
 
Oracle training 

Excel
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> Do we need REF CURSOR in FOR LOOPS
rivi10
post Feb 18 2012, 05:57 PM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 18-February 12
Member No.: 46,790



I am trying to understand the purpose of REF CURSOR.

Are strong ref cursor and weak cursor still applicable while using a FOR LOOP in a Cursor?

In the example I can use c_post.empid to display in this case.

Example:

DECLARE
CURSOR c_post IS select empid, empname from EMP;

BEGIN

FOR c_post in c_post LOOP

DBMS_OUTPUT.PUT_LINE('The value displayed is ' || c_post.empid);

END LOOP;

END;
Go to the top of the page
 
+Quote Post
burleson
post Feb 18 2012, 06:27 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,099
Joined: 26-January 04
Member No.: 13



Hi,

This is a DBA forum, but I have notes on ref cursors:

Please read:

http://www.dba-oracle.com/t_refcursor.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd April 2014 - 05:03 PM