adspace


Explain reference cursor?

Answer Posted / Bhasker Sah

A Reference Cursor is a type of cursor in Oracle PL/SQL programming language. Unlike a regular cursor, which stores the result set within the program's memory, a Reference Cursor returns a result set as a separate object that can be used elsewhere in the program or passed as an argument to another procedure or function. It provides better performance and flexibility for handling complex data sets.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of Dataware Control?

1125


Explain how to generate iqd file from framework manager?

1040


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6097


Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1053


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2354