Explain the two type of Cursors ?

Answer Posted / k minty

actually there are three types of cursors
1. static cursors which are further classified as implicit
cursors and explicit cursors
2. Dynamic Cursors
3. Reference Cursors.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are two statement types in sql?

745


Why do we use procedures in sql?

768


What is function and procedure in pl sql?

702


What is the difference between execution of triggers and stored procedures?

749


What is a record in a database?

770






which command using query analyzer will give you the version of sql server and operating system? : Sql dba

702


how to fetch alternate records from a table? : Sql dba

825


Does truncate require commit?

714


What does closing a cursor do?

982


How do you update sql?

711


What is meant by temporal data?

708


How to combine two stored procedures in sql?

802


Can we create table inside stored procedure?

696


what is the difference between myisam static and myisam dynamic? : Sql dba

768


How delete all records from table in sql?

721