How can you tell the difference between an index and a view?

0 Answers  

---

How does index help in query performance?

0 Answers  

---

Why do we use set serveroutput on?

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

What is trigger with example?

0 Answers  

---

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

---

Find out the 3rd highest salary?

51 Answers   BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

What do you mean by stored procedures? How do we use it?

0 Answers  

---

Why do we need view in sql?

0 Answers  

---

What does count (*) mean in sql?

0 Answers  

---