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 |
..........refers to the disk mirroring
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is rank function in sql?
What is sql in oracle?
How to run sql statements with oracle sql developer?
What is the use of triggers?
How do I save a stored procedure?
write the Sql query for creating database backup?
What is Temp Table and type of temp table?
How does cross join work in sql?
what is blob? : Sql dba
What is INSTEAD OF trigger ?