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 |
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is oracle database client?
Find all employees in Dept “Marketing”.
What is index in Oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Explain what are the type of synonyms?
How to filter out duplications in the returning rows using oracle?
How can I introduce multiple conditions in like operator?
How to loop through data rows in the implicit cursor?
Explain 1st, 2nd, 3rd normalization form of data base
What is a materialised view?
what is dynamic SGA and static SGA