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
Explain a private synonyms?
How to assign data of the deleted row to variables?
Can you have more than one content canvas view attached with a window ?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is the maximum number of triggers that can be applied to a single table?
How do we get field details of a table?
How will you differentiate between varchar & varchar2?
What are the limitations oracle database 10g xe?
State and explain the different types of data models?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what are archived logs?
How to define an anonymous procedure without variables?
What is background process in Oracle?
query optmization techniques and quwry analyser+projects+ppts
What are nested tables?