Interested to Buy Any Domain ? << Click Here >> for more details...
Types of cursors and explanation each of them ?
- 4 Answers
- 12802 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
How do you run a query?
What are aggregate and scalar functions?
what is a relationship and what are they? : Sql dba
What pl/sql package consists of?
Write a sql select query that only returns each name only once from a table?
What are sql procedures?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
How long does it take to learn pl sql?
What is foreign key in sql with example?
Is sql database free?
Can we call a function containing dml statements in a select query?
What are the types of sql commands?
What are tables and fields?
What is sqlerrd?
What are sql ddl commands?
