Explain uses of cursor.



Explain uses of cursor...

Answer / shwetha k

A cursor is a pointer to pointing to this memory area and used to retrieve data row by row instead of all row at a time.
select statement fetches only one row.so to overcome this problem cursor is used to hold the set of rows or data in one variable and can do whatever manipulation we want to do.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How many developers work on postgresql?

0 Answers  


what is overloading procedure or overloading function ?

3 Answers   Genpact,


how to create user in sql and how to set password for that?

3 Answers  


How do you take the union of two tables in sql?

0 Answers  


What is a pragma statement?

0 Answers  






discuss about myisam index statistics collection. : Sql dba

0 Answers  


What is PL/SQL table ?

6 Answers  


How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  


What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,


i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  


What is a boolean in sql?

0 Answers  


Define select, insert, create, delete, update, drop keywords

0 Answers  


Categories