What is reference cursor?

Questions by Naveen reddy

Showing Answers 1 - 12 of 12 Answers

gnanavelu

  • Nov 2nd, 2005
 

what is the reference of cursor and by through which we can see the created files

  Was this answer useful?  Yes

shuaib

  • Nov 11th, 2005
 

Refereence cursor is dynamic cursor used with SQL statement like For select* from emp;

  Was this answer useful?  Yes

Mahender singh

  • Feb 2nd, 2006
 

Refrence cursor is dynamic type of cursor which is assiociated multiple queries at run time.for example select * from EMP.

  Was this answer useful?  Yes

rnr

  • Feb 15th, 2006
 

ref cursor is a cursor . contentents of the cursor dynamically change depending on the requirements

  Was this answer useful?  Yes

Srinivas Reddy Modugu

  • Mar 14th, 2006
 

By using reference cursor we can get more then one record from the data base when we call the stored procedure using jdbc api.

This reference cursor is use full when we need to get more then one record from stored procedure. (jdbc API)

  Was this answer useful?  Yes

nandish

  • Mar 31st, 2006
 

i dont know what it means

  Was this answer useful?  Yes

hanuvalluri

  • Apr 11th, 2011
 

A REF CURSOR is basically a data type. A variable created based on such a data type is generally called a cursor variable. A cursor variable can be associated with different queries at run-time. The primary advantage of using cursor variables is their capability to pass result sets between sub programs (like stored procedures, functions, packages etc.).

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions