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 |
How to export several tables together?
What is the database name in oracle?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
How to select an oracle system id (sid)?
What is the maximum limit on the number of columns in a table?
How to write a query with a full outer join in oracle?
What do you understand by database schema and what does it hold?
How can I see all tables in oracle?
material view and view disadvantages?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records