why use cursors?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of triggers?

550


What is recursive stored procedure?

577


How is sql used in oracle?

560


What pl/sql package consists of?

605


What are the types of views in sql?

510






How do I access sql anywhere database?

481


what are properties of a transaction? : Sql dba

542


Can sql developer connect to db2?

561


What is trigger with example?

535


Why do we use joins?

539


What does an inner join do?

531


how would concatenate strings in mysql? : Sql dba

544


What is data type in sql?

529


Can we enter data in a table in design view?

495


What is the most common sql injection tool?

518