Explain the two type of Cursors ?

Answer Posted / tulsi

There are two types of cursors, Implict Cursor and Explicit
Cursor.
PL/SQL uses Implict Cursors for queries.
User defined cursors are called Explicit Cursors. They can
be declared and used.

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does sql*loader handles newline characters in a record? : aql loader

586


How many triggers can be applied on a table?

510


What are the types of triggers in sql?

496


What is keys and its types?

538


What is a constraint?

565






What is t sql in sql server?

564


Why do we use procedures in pl sql?

518


how to analyze tables with 'mysqlcheck'? : Sql dba

542


What mean sql?

576


What does joining a thread mean?

544


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

640


What is assignment operator in pl sql?

561


What is application trigger?

539


What are the dml statements?

682


What are the differences between implicit and explicit cursors?

517