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
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Can cursors be part of a trigger body?
What is a temp table?
what is unique key constraint? : Sql dba
How to display the records between two range in Oracle SQL Plus?
What is procedure function?
What is the difference between view and stored procedure?
What are different types of functions in sql?
How do you update a table in sql?
What is write ahead logging in sql server?
What does pl sql developer do?
How do I tune a sql query?
What are the sql aggregate functions?
Is primary key is clustered index?
State few characteristics of pl/sql?