How you open and close a cursor variable.Why it is required?

Answer Posted / venkat

open cursor then the cursor points to the starting of the data......close the cursor it clears the data after the execution of a program

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1524


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1557


What are the various constraints used in oracle?

642


How do I limit the number of oracle database connections generated by weblogic server?

650


What is rowid and rownum in oracle?

626






hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2043


State any two functions of oracle?

704


How do I uninstall oracle 11g?

641


Explain parameter file in oracle.

667


Explain the difference between a procedure and a function?

643


What is an oracle user role?

648


Explain do view contain data?

671


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1695


How is it different from a normal table?

653


what is reindexing?

1234