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 qualities of 2nf?

541


what are aggregate and scalar functions? : Sql dba

550


What is dynamic query?

539


How does postgresql compare to "nosql"?

578


How can you view the errors encountered in a trigger?

546






Differentiate between syntax and runtime errors.

640


Does a primary key have to be a number?

518


What is rtm in testing?

572


Explain architecture of sql server notification services?

620


How delete all data from table in sql?

568


what is an extent ? : Sql dba

580


What does truncate mean in sql?

534


How do you delete duplicates in sql query using rowid?

533


What is sql table?

518


How do I clear the screen in sql plus?

546