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 is sql*loader and what is it used for?
What is the purpose of design view?
What is procedure explain with program?
Explain 3 basic parts of a trigger.
what is bcp? When does it used? : Sql dba
Does pdo prevent sql injection?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is the difference between rollback and rollback to statements?
How do I view tables in sql developer?
What is difference between stored procedures and application procedures?
How can we store rows in PL/SQL using array?
I need a function for a train ticket reservation please answer it thanks in advance
what is foreign key? : Sql dba
What are its different types of dbms?
how tsql statements can be written and submitted to the database engine? : Transact sql