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
What is trigger in pl sql?
can sql servers linked to other servers like oracle? : Sql dba
How do I partition in sql?
Can you skip header records while loading? : aql loader
What is error ora-01000: maximum open cursors exceeded
Explain foreign key in sql?
What is materialized view in sql?
What will you get by the cursor attribute sql%notfound?
How to download oracle sql developer?
What is the difference between the sql*loader and import utilities? : aql loader
Do we need commit after truncate?
What are the advantages of sql?
What is clustered index sql?
Why truncate is used in sql?
What is a relationship and what are they?