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 the use of stored procedures?
What does inner join mean?
What is right join sql?
What is the difference between delete and truncate statement in sql?
What is dialect in sql?
What view means?
does sql support programming? : Sql dba
How do I order by ascending in sql?
What is sql deadlock?
What is percent sign in sql?
what is cursor. write example of it. What are the attributes of cursor.
What is data types in sql?
is mysql query is case sensitive? : Sql dba
What is the difference between left join and right join?
How to run sql*plus commands in sql developer?