Types of cursors and explanation each of them ?

Answer Posted / sohail

Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where are cookies actually stored on the hard disk? : Sql dba

573


What is the life of an sql statement?

519


What do you mean by stored procedures? How do we use it?

517


Is sql microsoft?

539


What is posting?

597






Is sqlite free?

529


What are the two virtual tables available at the time of database trigger execution?

627


Does sql require a server?

521


Is hadoop a nosql?

569


What is nosql db?

532


Explain the uses of database trigger.

648


Why is a trigger used?

519


How many joins in sql?

542


Why query optimization is needed?

509


what are different types of collation sensitivity? : Sql dba

549