why use cursors?
Answers were Sorted based on User's Feedback
Answer / suresh kumar somayajula
Cursor : It's a private SQL worksheet area where we can
execute SQL commands and processing information.
The purpose of the Cursor is, PL/SQL execution block will
process only one records means it will return only one
records.If we want to retrieve or process more number of
records we use the "Cursors".
These are of two types.
1. Implicit Cursor 2. Explicit cursors.
Thank you,
Suresh
| Is This Answer Correct ? | 30 Yes | 1 No |
Answer / aravind
Cursor is used to process multiple rows using pl/sql.
| Is This Answer Correct ? | 16 Yes | 4 No |
Answer / sri
mainly cursor is used to to process the multiple records
from database
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / selvaraj v , anna university c
Cursors allow row-by-row processing of the result sets.
Retrieve more than one rows from table or database to use
Curosrs.
| Is This Answer Correct ? | 2 Yes | 0 No |
How is pl sql different from sql?
Does inner join remove duplicates?
what are different types of keys in sql?
hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance
How does stored procedure reduce network traffic?
Can we use more than one null value for unique key?
31 Answers A1 Technology, Wipro,
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
what are integrity rules?
What are the sql aggregate functions?
Is sql a case sensitive language?
What is the diffrence between IN and EXISTS.which one is faster.
When is the explicit cursor used ?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)