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 natural join in sql?
Why do we go for stored procedures?
How to connect a sql*plus session to an oracle server?
What is materialized view. What are different methods of refresh?
When is the update_statistics command used?
What is auto increment in sql?
Is it possible to sort a column using a column alias?
Explain what is table in a database?
What is a left join?
how to write date and time literals? : Sql dba
what is isam? : Sql dba
What are dml commands?
Define SQL and state the differences between SQL and other conventional programming Languages?
Can we call stored procedure in function?
What is range partitioning?