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

Explain aggregate functions are available there in sql?

980

---

What is the default isolation level in sql server? : Transact sql

1010

---

what is 'mysqlcheck'? : Sql dba

994

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3989

---

Explain isolation levels. : Transact sql

1049

---

explain the advantages and disadvantages of stored procedure? : Sql dba

991

---

How do you break a loop in pl sql?

1032

---

How we can update the view?

1039

---

What is the left table in sql?

953

---

How do I run a program in pl sql?

989

---

what is the difference between a having clause and a where clause? : Sql dba

1062

---

How do I find sql profiler?

924

---

How many commands are there in sql?

1011

---

What is sql lookup?

906

---

What is the purpose of normalization?

1033

---