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
What are the different components of soa suite?
Tell me how to debug the report?
In oracle application how do you debug or trace errors?
what are the prerequisites for costing transactions?
What are the Standard Reports and Forms in HRMS?
What are do's and dont's of Interface?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
tell me the scenarios of the independent in reports
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What is oracle soa suite and what are its different components?
Can u give the Documentation of Custom.pll in oracle apps
List the types of flexfield?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Are you familiar with internet architecture of oracle apps 11i?
What do you understand by soa and what are the benefits of using this architecture?