10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.

3 Answers   Wipro,

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

---

What is the difference between implicit index and explicit index?

2 Answers   TCS,

---

What is hash cluster in oracle?

0 Answers  

---

Explain an extent?

0 Answers  

---

How do I manually uninstall oracle client?

0 Answers  

---

What are the types of Database Links ?

2 Answers  

---

Explain the family trees and connection by clause

0 Answers  

---

How to connect asp pages to oracle servers?

0 Answers  

---

What is difference between SUBSTR and INSTR?

1 Answers  

---