How you open and close a cursor variable.Why it is required?
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 |
What are operators in oracle?
can u plz provide me oca sql dumps please i need them
How to create a single index for multiple columns?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is bulk collect in oracle?
what happened to the global index when I truncate the data in one of the partition?
what is the exact definition for pointer?
Difference between oracle's plus (+) notation and ansi join notation?
What is bulk copy or bcp in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is the max number of columns in an oracle table?