Answer / guest

CHOOSE,ALL_ROWS,FIRST_ROWS and RULE

What are inner join and outer join?

3 Answers  

---

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

3 Answers   Wipro,

---

Hi Can any one tell me what are the API's used in requisition import.

0 Answers  

---

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

---

What is flashback Query ? And Use ?

4 Answers   Thermotech,

---

Define Transaction ?

5 Answers  

---

Difference between cartesian join and cross join?

0 Answers  

---

Does oracle partitioning improve performance?

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,

---

What is hot backup and logical backup?

0 Answers  

---

How to bring a tablespace online?

0 Answers  

---

find out the third highest salary?

92 Answers   CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

---