What is the use of cursor ? how cursor allocate context area for executing the sql statement?
- 4 Answers
- 15292 Views
- HCL, I also Faced
- E-Mail Answers
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 sql query to display the current date?
What is execute immediate?
what is a relationship and what are they? : Sql dba
What does (+) mean in sql joins?
Define commit?
How does postgresql compare to "nosql"?
What are pl sql data types?
Which is better join or inner query?
what are the 'mysql' command line options? : Sql dba
what is the difference between a having clause and a where clause? : Sql dba
Is primary key clustered index?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is raid? How does it help storage of databases?
What is left join example?
What is varchar example?
