What are the cursor attributes used in PL/SQL ?

Answers were Sorted based on User's Feedback



What are the cursor attributes used in PL/SQL ?..

Answer / rajesh

The cursor attributes are
%rowcount
%found
%notfound
%isopen
if u have any issue contact me at
rajesh.natesh@gmail.com,rajesh.natesh@cognizant.com

Is This Answer Correct ?    8 Yes 0 No

What are the cursor attributes used in PL/SQL ?..

Answer / 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

What are the cursor attributes used in PL/SQL ?..

Answer / nishi

The cursor attributes are

%rowcount

%found

%notfound

%isopen

Is This Answer Correct ?    0 Yes 0 No

What are the cursor attributes used in PL/SQL ?..

Answer / gireesh.p.v

%type
%rowtype
contact me gireesh.p.v@gmail.com

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More SQL PLSQL Interview Questions

What is dynamic sql in pl sql?

0 Answers  


What is the difference between delete and truncate commands?

0 Answers  


What is sql and explain its components?

0 Answers  


What are the different set operators available in sql?

0 Answers  


What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,


Is pl sql better than sql?

0 Answers  


How to get each name only once from an employee table?

0 Answers  


What is sql and db2?

0 Answers  


What is the difference between a subquery and a join?

0 Answers  


How to remove duplicate rows from a table?.

3 Answers  


Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,


Which sql statement is used to return only different values?

0 Answers  


Categories