why use cursors?

Answers were Sorted based on User's Feedback



why use cursors?..

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

why use cursors?..

Answer / aravind

Cursor is used to process multiple rows using pl/sql.

Is This Answer Correct ?    16 Yes 4 No

why use cursors?..

Answer / sri

mainly cursor is used to to process the multiple records
from database

Is This Answer Correct ?    2 Yes 0 No

why use cursors?..

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

why use cursors?..

Answer / chandu

to perform multiple rows accessing.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

..........refers to the disk mirroring

2 Answers   iFlex,


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  


What is rank function in sql?

0 Answers  


What is sql in oracle?

0 Answers  


How to run sql statements with oracle sql developer?

0 Answers  






What is the use of triggers?

0 Answers  


How do I save a stored procedure?

0 Answers  


write the Sql query for creating database backup?

7 Answers   TCS,


What is Temp Table and type of temp table?

1 Answers   HP, SLK,


How does cross join work in sql?

0 Answers  


what is blob? : Sql dba

0 Answers  


What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,


Categories