Answer / Neha Tewari

The cursor attribute 'sql%rowcount' returns the number of rows affected by the last SQL statement executed within the cursor.

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

What is having clause in sql?

1 Answers  

---

what are Dynamic SQL statements?

9 Answers  

---

Can we use commit inside a trigger?

1 Answers  

---

How do you declare a user-defined exception?

1 Answers  

---

What is output spooling in sql*plus?

1 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

What are the qualities of 2nf?

1 Answers  

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

What is correlated sub-query?

7 Answers   Oracle,

---

What is the primary key?

1 Answers  

---