How do I limit the number of rows returned by an oracle query after ordering?

0 Answers  

---

Explain the use of full option in exp command.

0 Answers  

---

what is exact difference between drop and truncate table.

3 Answers  

---

7. Repeat query (7) but also display all clients who have never ordered anything.

1 Answers   Wipro,

---

Explain overloading. Can functions be overloaded?

0 Answers  

---

---

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers  

---

What are main difference between Stored Procedure and Functions.

6 Answers   CA, Metric Stream,

---

What is the difference between view and materialized view in Oracle?

0 Answers   MCN Solutions,

---

What is the difference between Sleep and Wait? (Java)

1 Answers   RBS,

---

Explain table?

0 Answers  

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

0 Answers  

---

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,

---