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

Is the primary key an index?

765


define sql delete statement ? : Sql dba

745


What is crud stand for?

746


What is latest version of sql?

713


Explain the significance of the & and && operators in pl sql.

748






How to place comments in pl/sql?

797


What is time based sql injection?

690


What is recursive join in sql?

752


what is data integrity? : Sql dba

782


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

714


what is sql? : Sql dba

741


What do we need to check in database testing?

727


What is row_number () in sql?

732


What is offset and limit in sql?

744


What is cursor in pl sql with examples?

674