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

What is ordinary table in oracle?

643


What is meant by recursive hints in oracle?

613


please explain.. DB architecture ...

1553


Explain the use of full option in exp command.

583


Explain an exception and its types?

603






How to retrieve data from an cursor to a record?

559


What are the types of trigger in oracle?

571


Is there an oracle sql query that aggregates multiple rows into one row?

540


What is PL/SQL ?

1106


How to insert a record into a table?

630


Is the After report trigger fired if the report execution fails ?

2398


What is the usage of merge statement?

663


Explain implicit cursor.

551


What is a proxy object?

575


Can we write dml statement in function in oracle?

628