Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Explain ddl statements in pl/sql?

0 Answers  


What mean sql?

0 Answers  


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,


What are dml commands?

0 Answers  


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  






What are different types of tables in sql?

0 Answers  


Which kind of parameters cannot have a default value in pl sql?

0 Answers  


What is cartesian join in sql?

0 Answers  


I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  


what is schema? : Sql dba

0 Answers  


How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  


how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  


Categories