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

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,


What are crud methods?

0 Answers  


What is difference between primary and secondary key?

0 Answers  


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  


How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  






table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,


How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,


How many rows will return from dual table?

4 Answers   Fujitsu,


How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,


What is varchar example?

0 Answers  


Does oracle use sql?

0 Answers  


Is keyword pl sql?

0 Answers  


Categories