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

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.

Answer / nishi

The cursor attributes are

%rowcount

%found

%notfound

%isopen

Answer / gireesh.p.v

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

What is error ora-01000: maximum open cursors exceeded

0 Answers  

---

What is sap sql anywhere?

0 Answers  

---

what is recursive stored procedure? : Sql dba

0 Answers  

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

Can u create a primary key with out unique index.

8 Answers  

---

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

Explain the working of foreign key?

0 Answers  

---

How to return an array from java to pl/sql?

0 Answers  

---

Can we create view in stored procedure?

0 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

What are the different dcl commands in sql?

0 Answers  

---