Types of cursors and explanation each of them ?

Answer Posted / aditya

Ref cursor have two types strong ref cursor and weak ref cursor.

declaring a ref cursor and using it for multiple select statements is a weak cursor.

using a ref cursor as an out parameter to get a result set is a strong ref cursor.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the most important ddl statements in sql?

565


How many indexes can be created on a table in sql?

490


Define concurrency control. : Transact sql

582


What is the difference between delete and truncate commands?

508


what is foreign key? : Sql dba

579






What is foreign key and example?

502


What is the use of stored procedures?

513


Explain the difference between sql and mysql.

558


what are integrity rules?

560


How do you sort in sql?

594


what are the types of join and explain each? : Sql dba

527


What is sqlite used for?

520


What is data types in sql?

529


What is data control language?

526


how to convert character strings to numeric values? : Sql dba

566