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
What are literals in sql server?
What is the difference between partition and index?
How exception handling is done in advance pl/sql?
How much ram can sql express use?
What is scalar and vector?
what is the difference between a web-garden and a web-farm? : Sql dba
Are stored procedures faster than queries?
What are the two types of exceptions in pl/sql?
What is sql indexing?
What is the difference between the conventional and direct path loader? : aql loader
What are the two virtual tables available at the time of database trigger execution?
explain the difference between myisam static and myisam dynamic. : Sql dba
How to display the current date in sql?
What is sql stand for?
What is the use of index in sql?