Why do we use coalesce function in oracle?

0 Answers  

---

Explain oracle left join with an example?

0 Answers  

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,

---

What is index-organized table in Oracle?

0 Answers   MCN Solutions,

---

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

2 Answers   Wipro,

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

How would you design a database for an e-commerce website?

1 Answers  

---

What are the differences between date and timestamp in oracle?

0 Answers  

---

Can you have more than one content canvas view attached with a window ?

0 Answers   Oracle,

---

Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---

defination of bitmap index

0 Answers   NIIT,

---

What are Schema Objects ?

2 Answers  

---