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 pl/sql table? Why is it used?
how to increment dates by 1 in mysql? : Sql dba
define primary key & secondary key?
What is having clause in sql?
Explain what is a view?
how do you tune the slow running queries in oracle db , explain the methodology
How to test for null values?
I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?
Is primary key clustered index?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 Answers Metric Stream, Polaris,
What is indexing oracle sql?
What are pl/sql cursors?
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)