Interested to Buy Any Domain ? << Click Here >> for more details...
How you open and close a cursor variable.Why it is required?
- 2 Answers
- 3653 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 |
How to define an anonymous procedure with variables?
How to convert csv to table in oracle?
What is the difference between substr & instr functions?
What is execute immediate in oracle?
What is oracle host variable?
Explain what does a control file contain?
Explain about the analyze command in oracle?
What are the Characteristics of Data Files ?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
query to find the maximum no persons with same age(age colomn) from emp table
What is a deadlock in SQL? How can you prevent it?
How to change program global area (pga) in oracle?
Oracle General 
