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

What are the benefits of using soa architecture?

718


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

1915


what is pay run id ?

1717


Can we create tables in apps schema?

642


How do you register report in oracle apps?

638






Tell me where we find the status of order information?

681


How many schemas we have? how many you have used?

1627


In hierarchical structure of a database? we have write query from where we should start?

1718


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

1896


please send me forms, xml pulisher questions,answers

1667


what are the different transaction clauses in AR?

1612


what are the prerequisites for costing transactions?

2641


Which oracle apps version you are very confident in?

718


tell me the scenarios of the independent in reports

2061


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

3092