How you open and close a cursor variable.Why it is required?
- 2 Answers
- 3171 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 empty your oracle recycle bin?
What are the execution control statements?
How to list all indexes in your schema?
What is currency type in database ?
What is oracle in java?
How to check database size in Oracle?
Can I create users through internet explorer in oracle 10g?
What are the advantages of oracle 12c?
how will I find the first 5 highest salaried employees in each dept in oracle.
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is a trigger and what are its types in oracle?
Tell me New Feature of Oracle 10g?
Oracle General 
