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 |
What is the main reason behind using an index?
can we call a procedure from a function?
Can you have multiple SPs with the same name on a database?
Explain the components of sql?
How to find only %th Highest Sal
how to use case expression? : Sql dba
What is trigger and how to use it in sql?
What is a sql*loader control file?
How do I delete a trigger?
What is group function in sql?
write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
What is the left table in sql?
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)