Types of cursors and explanation each of them ?
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 is mutating error in pl sql?
What is primary key and foreign key with example?
How to run sql commands in sql*plus?
If a cursor is open, how can we find in a pl/sql block?
What is the difference between local variables and global variables?
Which one is better subquery or joins?
what is the difference between inner and outer join? Explain with example. : Sql dba
Why do you partition data?
How do I know if I have sql express or standard?
What is primary key secondary key alternate key candidate key?
Is sql better than excel?
What is a table?
What is scope of pl sql developer in future?
What is optimistic concurrency control? : Transact sql
What is the difference between join and natural join?