What is the use of cursor ? how cursor allocate context area for executing the sql statement?

Answer Posted / ragaventhar

Cursor is used to fetch the data from a main table to temporary variable at run time and it is affected row by row .Mainly used to stored a data temporary and give the result set at the time of run time

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are literals in sql server?

651


What is the difference between partition and index?

564


How exception handling is done in advance pl/sql?

593


How much ram can sql express use?

605


What is scalar and vector?

636






what is the difference between a web-garden and a web-farm? : Sql dba

660


Are stored procedures faster than queries?

610


What are the two types of exceptions in pl/sql?

640


What is sql indexing?

657


What is the difference between the conventional and direct path loader? : aql loader

750


What are the two virtual tables available at the time of database trigger execution?

756


explain the difference between myisam static and myisam dynamic. : Sql dba

606


How to display the current date in sql?

681


What is sql stand for?

651


What is the use of index in sql?

661