Is subquery faster than join?

0 Answers  

---

Can I create table without primary key?

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

What is db journal file?

0 Answers  

---

How does pl sql work?

0 Answers  

---

---

What is the starting oracle error number?

0 Answers  

---

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

What is composite data type in pl sql?

0 Answers  

---

What do you understand by case manipulation functions?

0 Answers  

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---