Types of cursors and explanation each of them ?
- 4 Answers
- 11637 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / giri
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.sql%found,sql%notfound,sql%is open,sql%count these are the implicit cursor attributes.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.%found,%notfound,%is open,%count these are the explicit cursor attributes.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you mean by “trigger” in sql?
how to include comments in sql statements? : Sql dba
Why primary key is required?
What is a table?
Can there be 2 primary keys in a table?
What is equi join in sql?
What are all types of user defined functions?
What are the set operators in sql?
Is there a 64 bit version of ssms?
Can we insert data into view?
Can function return multiple values in sql?
Which join is like an inner join?
What are aggregate functions in sql?
Define select, insert, create, delete, update, drop keywords
What is difference between rank () row_number () and dense_rank () in sql?
