narendra kumar mshar

• Jun 12th, 2006

 

ans:  Ref cursor is used for dynamic where clause ,and it is used for fast processing

by

Narendra kumar and Friend

shriram Group COmp(Madras) New Delhi

erkamranrkgit

 Profile Answers by erkamranrkgit 

• Jun 26th, 2006

 

Normally in cursors, query is defined at the time the cursor is created.

 but in some cases, the query we need to use for a cursor is unknown until run-time. Oracle uses ref-cursors and cursor variables to satisfy this requirement.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

 

The scope of cursor is limited to a block/ programme.  here block/ programme means upto a end of procedure/function and only one fixed query can be attached to that cursor.

where as the scope of ref cursor is global. Generally ref cursor is used with package so diffrent internal procedure/function of that package can use this ref cursor with diffrent query. so one cursor can have multiple query.

sandip01

 Profile Answers by sandip01 Questions by sandip01

• May 25th, 2010

 

Ref cursor is generally used to return value to client side programme.
The advantage of ref cursor is it can associate with different quries at runtime.

suresh reddi

• Aug 19th, 2011

 

Using ref cursor we can pass different values( i.e by changing parameters) to the cursor which is declared in the package specification from the package body.

Ref cursors are of 2 types

a) weak ref cursor ie., ref cursor not having return clause
b) Strong ref cursor ie., ref cursor having return type

Deepika S Verma

• Mar 10th, 2014

 

Ref Cursors are used in two conditions
(1) When we have a dynamic query, means when we get the information at runtime related to query(like column name, table name etc)
(2) Or when we want to pass whole resultset to another proc/func.