How you open and close a cursor variable.Why it is required?
Answer Posted / nishi
OPEN cursor variable FOR SELECT...Statement
CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why does for update in oracle 8 cause an ora-01002 error?
What to do if the binary spfile is wrong for the default instance?
What are the execution control statements?
What do you mean by merge in oracle?
How do I connect to oracle?
please explain.. DB architecture ...
what is the difference between substr and instr function in oracle?
Explain the use of file option in exp command.
Which are the five query types available in oracle?
What are the differences between date and timestamp in oracle?
What are the various constraints used in oracle?
Explain the different normalization forms?
What is tns service name?
What are the ways tablespaces can be managed and how do they differ?
what are the advantages of running a database in archive log mode?