Interested to Buy Any Domain ? << Click Here >> for more details...
How you open and close a cursor variable.Why it is required?
- 2 Answers
- 3864 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 can we Update a table with out using UPDATE command?
What's dateware house and what's clustor with practicle example
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
how to genarate random numbers in oracle for particular row?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
what is difference between foreign key and reference key
how to find the n'th highest salary from emp ?
Why is oracle so popular?
Explain constraining triggers.
Explain the difference between a procedure and a function?
can we pass two out parameters at a time in function?please answer to my question
How to define Data Block size ?
Oracle General 
