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 the plv (pl/vision) package offers?
What is row_number () in sql?
How can get second highest salary in sql?
Can dml statements be used in pl/sql?
Why are indexes and views important to an organization?
What is sql procedures and functions?
How to avoid using cursors?
Explain mutating table error.
What is a trigger word?
how to get help information from the server? : Sql dba
How are sql commands classified?
How do I view a view in sql?
What is an escape character in sql?
What is the most common sql injection tool?
what are the features and advantages of object-oriented programming? : Sql dba