Ramprasad K

• Jun 1st, 2006

 

Hi,

For your kind information its not REP CURSOR, its Ref Cursor.

Ref Cursor is a Cursor which dynamically assigns the condition(s)

-Regards,

Rama Krishna,Yerra

• Aug 2nd, 2006

 

The main Use of Rep Cursor is a cursor without any select statement..

We have to declare the ref cursor in a package and we can recreate the instance of that cursor in the pl/sql block dynamically..

Thanks&Regds

Ramki,TCS,Deccan Park,Hyd

Venkata Ramana

• Sep 14th, 2006

 

Ref cursor is like pointers in C langugae which will point the address of the memory not the result set.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

 

 any cursor which can be assigned a dynamic sql statement is called a ref cursor.  Generaly it is declared in package so that it becomes global and any query can be attached to it.

nambiaruran

• Jul 2nd, 2007

 

Ref cursor is a cursor variable used to point a cursor statement. Ref cursor mainly used for returning the cursor values.

fiaskhan

 Profile Answers by fiaskhan Questions by fiaskhan

• Dec 4th, 2008

 

Ref cursor are used to define cursor variables. It acts as a pointer for memory area.
In a single memory location (context area) we can write any number of select statement. Mainly it is used when you want to fetch data from more than one table.

hindol_saha

 Profile Answers by hindol_saha Questions by hindol_saha

• Jan 19th, 2010

 

Ref cursor is used for dynamic cursor based on different where clause ,and it is used for fast processing 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.
:)