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
What is ordinary table in oracle?
What is meant by recursive hints in oracle?
please explain.. DB architecture ...
Explain the use of full option in exp command.
Explain an exception and its types?
How to retrieve data from an cursor to a record?
What are the types of trigger in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
What is PL/SQL ?
How to insert a record into a table?
Is the After report trigger fired if the report execution fails ?
What is the usage of merge statement?
Explain implicit cursor.
What is a proxy object?
Can we write dml statement in function in oracle?