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
How to call a stored function with parameters?
Which is better Oracle or MS SQL? Why?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is system tablespace?
How to set a transaction to be read only in oracle?
Explain a private synonyms?
What are the database administrators utilities available?
How to change system global area (sga) in oracle?
Please explain oracle left join with an example?
How do I uninstall oracle 11g?
Explain what are the type of synonyms?
When system tablespace is created?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to create a table index?
Why do you create or replace procedures rather that drop and recreate.