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


Please Help Members By Posting Answers For Below Questions

What is the plv (pl/vision) package offers?

617


What is row_number () in sql?

546


How can get second highest salary in sql?

509


Can dml statements be used in pl/sql?

579


Why are indexes and views important to an organization?

527






What is sql procedures and functions?

531


How to avoid using cursors?

599


Explain mutating table error.

649


What is a trigger word?

516


how to get help information from the server? : Sql dba

528


How are sql commands classified?

595


How do I view a view in sql?

508


What is an escape character in sql?

564


What is the most common sql injection tool?

545


what are the features and advantages of object-oriented programming? : Sql dba

549