Types of cursors and explanation each of them ?
Answer Posted / anusha
Cursor is a private work area .there are
three types if cursors
1.implicit cursor: implicit cursors is create,open and
closed by system automatically.
2.explicit cursor: explicitly user can create,open and close
cursors.
3. ref cursor: Reference cursor is a cursor dynamically (at
Run time) we can pass the column names or table names.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can a foreign key be a duplicate?
How do I find duplicates in the same column?
what is the command line end user interface - mysql? : Sql dba
Is sql pronounced sequel or sql?
What is sql engine in oracle?
Can I create table without primary key?
How many types of functions are there in sql?
Is postgresql a server?
What does desc stand for?
What is cost in sql execution plan?
Why is partition used in sql?
How do I view output in sql developer?
What is a unique key and primary key and foreign key?
What are the various levels of constraints?
Why left join is used in sql?