Interested to Buy Any Domain ? << Click Here >> for more details...
Types of cursors and explanation each of them ?
- 4 Answers
- 12817 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 is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
Is left join faster than inner join?
Where can I learn sql for free?
What is full form of rtm?
What are the three pl sql block types?
Enlist the data types that can be used in pl/sql?
Can a foreign key have a different name?
Explain lock escalation? : Transact sql
How bulk collect improves performance?
What is rank dense_rank and partition in sql?
what is a constraint? Tell me about its various levels. : Sql dba
List the different type of joins?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What are the features of pl sql?
Can I learn sql in a week?
