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
where to define interorganization transaction charges and what are the different options?
Is soa a part of oracle fusion middleware?
What does appl_top directory contain?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
what is pay run id ?
Which oracle apps version you are very confident in?
how can i print random rows in plsql table
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
q)what are the validations in sql*loader
How can you achieve loose coupling in soa framework?
What are do's and dont's of Interface?
what is global tempory table?
What is sca and how is it useful?
In support project one ticket alloted which steps follows manualy tell me ?
What do you understand by a set of books?
