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
Can we insert in sql function?
What is trigger in pl sql?
What is union and union all keyword in sql and what are their differences?
What are aggregate and scalar functions?
What is synchronized subquery?
what are aggregate and scalar functions? : Sql dba
Why truncate is faster than delete?
What is sql trigger example?
what is log shipping? : Sql dba
How to call a javascript function from pl sql?
What is basic structure of pl sql?
How many types of normalization are there?
How many commands are there in sql?
How to Execute a Package in PL/SQL.?
What is benefit of creating memory optimized table?