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

What is difference between pl and sql?

711


Explain the difference in execution of triggers and stored procedures?

748


What are the different dml commands in sql?

762


what are the drivers in mysql? : Sql dba

736


what is sql server agent? : Sql dba

772






How do you declare a constant?

708


Explain the order of sql statement execution?

806


What are the properties of a transaction?

793


How does rowid help in running a query faster?

1155


What is bind reference and how can it be created?

771


Can unique keys be null?

663


what is the stuff function and how does it differ from the replace function? : Sql dba

788


What is difference between inner join and cross join?

715


What are the types of views in sql?

748


Why is partition used in sql?

785