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
Tell me where we find the status of order information?
what are the prerequisites for costing transactions?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
How many schemas we have? how many you have used?
What do you understand by a set of books?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Explain oracle apps architecture.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Explain what are the tables of auto invoice?
In support project one ticket alloted which steps follows manualy tell me ?
Which oracle apps version you are very confident in?
What is instead of trigger in where we will use?
In sequence i want to 11 and 15th values how we will write?
What do you understand by concurrent programs?
What are the different components you should consider while defining a responsibility in oracle apps?