Answer Posted / shwetha k
A cursor is a pointer to pointing to this memory area and used to retrieve data row by row instead of all row at a time.
select statement fetches only one row.so to overcome this problem cursor is used to hold the set of rows or data in one variable and can do whatever manipulation we want to do.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is offset and limit in sql?
Can triggers stop a dml statement from executing on a table?
What is Difference Between Unique and Primary Key Constraints?
What are analytic functions in sql?
What is rownum and rowid?
How do I clear the screen in sql plus?
What is compilation error in pl sql?
what is isam? : Sql dba
How do I save the results of sql query in a file?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What is the maximum rows in csv?
What are basic techniques of indexing?
What is the use of triggers?
Why is the cursor important?
What is difference between inner join and self join?
