What are the cursor attributes used in PL/SQL ?

Answer Posted / pandu

Hi,
Cursor Attributes
1)Isopen
2)Found
3)Not Found
4)rowCount

but ,we cursor's are two types
Namely 1)Implicit Cursor
calling the attibutes as SQL%ISOPEN
2)Explicit cursor
calling the Attiributes as CursoName%ISOPEN.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cold data?

498


What are the different types of joins in sql?

579


How global cursor can be declare with dynamic trigger ?

1741


Why do we use sql constraints? Which constraints we can use while creating database in sql?

543


What is pl sql in oracle?

569






Is nosql relational?

544


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

490


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

574


How many functions are there in sql?

532


How to combine two stored procedures in sql?

587


Explain clause in sql?

552


Is and as keyword in pl sql?

509


Why do we use %rowtype & %type in plsql?

593


Do stored procedures prevent sql injection?

540


what are the advantages of mysql in comparison to oracle? : Sql dba

521