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

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

What are the advantages of normalization?

0 Answers  

---

Explain the commit statement.

0 Answers  

---

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,

---

Can we insert data into materialized view?

0 Answers  

---

---

What are the different dcl commands in sql?

0 Answers  

---

What is the use of <> sql?

0 Answers  

---

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---

what are date and time data types in mysql? : Sql dba

0 Answers  

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---

What information is needed to connect sql*plus an oracle server?

0 Answers  

---

How do you change a value in sql?

0 Answers  

---