What is REF Cursor?

Answer Posted / shukla

Ref Cursor is a PL/SQL Datatype. This is used to store
result of a query. Ref cursor is used in situations when
you want to encapsulate logic within sub-program i.e. your
query is changing depending on certain criterian. This
reduces the complexity of our program if we were to
implement same logic in a single query for getting the
desired output.

Is This Answer Correct ?    59 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain oracle apps architecture.

763


In support project one ticket alloted which steps follows manualy tell me ?

2221


What are the benefits of using soa architecture?

709


Explain what are the tables of auto invoice?

647


Can you differentiate between mediator and osb?

626






what are the balancing segments in AR?

1647


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1799


List the various types of value set.

620


how can develope the po variance and po summary report? with tables mandatory columns and query please?

1975


What are the different components of soa suite?

721


List the types of flexfield?

605


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1684


how do you describe O2C along with tables

2309


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

1905


How is choreography different from orchestration?

648