WHAT IS REFCURSOR IN ORACLE ?

Answer Posted / srinivasa reddy k

In Oracle RefCursor is a cursor where we can change the
select statement dynamically.

First a Refcursor Variable should be declared in
Declaration Part

Refcursor Variable is like a normal variable, I.e. we can
change the value of variable at any time..,similarly now
Refcursor Variable can be changed with any sql query...

Is This Answer Correct ?    17 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where to define interorganization transaction charges and what are the different options?

2040


What are the Standard Reports and Forms in HRMS?

1855


What is sca and how is it useful?

746


What is instead of trigger in where we will use?

755


What are the different components you should consider while defining a responsibility in oracle apps?

737






can we use look up type instead of a pofile option?or valueset?is it possible how?

1870


What are do's and dont's of Interface?

1993


What are the different components of soa suite?

817


How many schemas we have? how many you have used?

1705


tell me the scenarios of the independent in reports

2221


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2007


Can you explain the difference between architecture followed in 10g & 11g?

747


please send me forms, xml pulisher questions,answers

1772


How to move the one file from one instance to another instance? And your scripts also?

697


what are the prerequisites for costing transactions?

2748