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 a nested table in word?
What are the differences between implicit and explicit cursors?
What is time based sql injection?
Give the structure of the function ?
What is nvarchar in sql?
What is normalisation and its types?
How do I run a sql script?
what does it mean to have quoted_identifier on? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);
how to do backup entire database? : Transact 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)