WHAT IS REFCURSOR IN ORACLE ?

Answer Posted / kishore

ref cursor is a dynamic cursor.ref cursor returns different
work area in memory.
THere are two types of cursor variable
1)week ref cursor
: if we don't include a return clause in the cursor.
2)strong ref cursor
:A ref cursor with a return clause.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a value set? List its various types.

658


What is oracle soa suite and what are its different components?

659


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1767


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2599


What does appl_top directory contain?

662






do you know is it possible to run the interface without using oracle apps?

660


what is the difference between request group and request security in oracle apps?

5064


tell me the scenarios of the independent in reports

2126


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


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2475


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

1718


where to define interorganization transaction charges and what are the different options?

1964


In support project one ticket alloted which steps follows manualy tell me ?

2230


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1696