Interested to Buy Any Domain ? << Click Here >> for more details...
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 a system versioned table?
What are synonyms in sql?
How many unique keys can a table have?
How do I view output in sql developer?
How long it takes to learn pl sql?
What packages(if any) has oracle provided for use by developers?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
Why are sql stored procedures used?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
what is the difference between sql and t-sql? : Transact sql
Can I create table without primary key?
what is a trigger? : Sql dba
how can we optimize or increase the speed of a mysql select query? : Sql dba
How can I get the number of records affected by a stored procedure?
how to drop an existing index in mysql? : Sql dba
