Interested to Buy Any Domain ? << Click Here >> for more details...
Types of cursors and explanation each of them ?
- 4 Answers
- 12779 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
Can we update views in sql?
how to show all tables with 'mysql'? : Sql dba
State some properties of relational databases?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is sql and also describe types of sql statements?
Why do we create views in sql?
What is nested table in pl sql?
What is constant in pl sql?
State few characteristics of pl/sql?
Is subquery faster than join?
What is the advantage of index in sql?
Can a composite key be null?
Why partition by is used in sql?
Why query optimization is needed?
What is memory optimized?
