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

How to see the table columns used in an index?

589


Explain user account with reference to oracle.

528


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1854


What exactly do quotation marks around the table name do?

544


How to login to the server without an instance?

616






How to define an anonymous procedure without variables?

545


How to view the data files in the current database?

592


Can sub procedure/function be called recursively?

532


Which is better Oracle or MS SQL? Why?

5431


How to create an oracle database manually?

568


what happened to the global index when I truncate the data in one of the partition?

1515


What is Reduced List of Values?

1700


When do you get a .pll extension in oracle? Explain its importance

572


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1357


What are internal user account in oracle?

567