Interested to Buy Any Domain ? << Click Here >> for more details...
How you open and close a cursor variable.Why it is required?
- 2 Answers
- 3810 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 handle exceptions in post production
what r routers?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Which is faster join or subquery in oracle?
How to fetch the row which has the max value for a column?
What happens if you set the sga too low in oracle?
How to download oracle database 10g xe?
What is oracle rowcount?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
12. Display the client name in upper case only and in lower case only.
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
What is the difference between alert log file and trace file ?
Oracle General 
