Interested to Buy Any Domain ? << Click Here >> for more details...
How you open and close a cursor variable.Why it is required?
- 2 Answers
- 3758 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 use an explicit cursor without open statements?
What is bulk copy or bcp in oracle?
What would you do with an in-doubt distributed transaction?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
How to call a stored function with parameters?
What is rowid and rownum in oracle?
How to see the table columns used in an index?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to use existing values in update statements using oracle?
what are the disadvantages of hierarchial database over RDBMS?
How to call a sub procedure?
What is a sub query and what are the different types of subqueries?
Oracle General 
