Types of cursors and explanation each of them ?
Answer Posted / sohail
Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is sql dialect?
Explain spool.
What is database sql?
What is primary key and foreign key?
What is output spooling in sql*plus?
What is the use of procedures?
What is the difference between between and in condition operators?
Advantages and disadvantages of stored procedure?
What is the difference between an inner join and an outer join?
What is dml and ddl?
What is the difference between left join and right join?
Can we commit in trigger?
How do I remove sql plus from windows 10?
What is coalesce sql?
How do you clear the screen in sql?