How you open and close a cursor variable.Why it is required?
- 2 Answers
- 2967 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Can a View based on another View ?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
Can a Tablespace hold objects from different Schemes ?
What is Reduced List of Values?
What are the data types in oracle?
What happens if you use a wrong connect identifier?
What are the different types of modules in oracle forms?
Explain the characteristics of oracle dba?
how will I find the first 5 highest salaried employees in each dept in oracle.
What are the Limitations of a CHECK Constraint ?
how do get database name at sql prompt?
What is TNS File
Oracle General 
