What are the cursor attributes used in PL/SQL ?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / nishi
The cursor attributes are
%rowcount
%found
%notfound
%isopen
Is This Answer Correct ? | 0 Yes | 0 No |
%type
%rowtype
contact me gireesh.p.v@gmail.com
Is This Answer Correct ? | 1 Yes | 8 No |
What is dynamic sql in pl sql?
What is the difference between delete and truncate commands?
What is sql and explain its components?
What are the different set operators available in sql?
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
Is pl sql better than sql?
How to get each name only once from an employee table?
What is sql and db2?
What is the difference between a subquery and a join?
How to remove duplicate rows from a table?.
Authentication mechanisms in Sql Server ?
Which sql statement is used to return only different values?