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 write date and time literals in oracle?
material view and view disadvantages?
What is an UTL_FILE.What are different procedures and functions associated with it?
What are the different oracle database objects?
List the parts of a database trigger.
What is an Oracle index?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How many memory layers are in the oracle shared pool?
what is difference between where clause and having clause?
Can group functions be mixed with non-group selection fields?
What is the difference between postgresql and oracle?