State the advatage and disadvantage of Cursor's?

2 Answers  

---

How do I audit the sql sent to the server?

0 Answers  

---

What are instead of triggers?

0 Answers  

---

What language is oracle sql developer?

0 Answers  

---

What is indexes?

0 Answers  

---

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

How does left join work in sql?

0 Answers  

---

Can we use two order by clause in query?

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,

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

what is sql and plsql

6 Answers  

---

What is materialized view. What are different methods of refresh?

0 Answers  

---