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 benefits of using soa architecture?
What are do's and dont's of Interface?
what is pay run id ?
Can we create tables in apps schema?
How do you register report in oracle apps?
Tell me where we find the status of order information?
How many schemas we have? how many you have used?
In hierarchical structure of a database? we have write query from where we should start?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
please send me forms, xml pulisher questions,answers
what are the different transaction clauses in AR?
what are the prerequisites for costing transactions?
Which oracle apps version you are very confident in?
tell me the scenarios of the independent in reports
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in