Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).

1 Answers  

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

0 Answers   ESS,

---

Why is oracle used?

0 Answers  

---

Write a simple Store procedure and pass parameter to it ?

3 Answers   Keane India Ltd,

---

What is pragma autonomous transaction in oracle?

0 Answers  

---

Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,

---

Explain the family trees and connection by clause

0 Answers  

---

how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,

---

What is a Schema ?

6 Answers  

---

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

---

How to experiment a data lock in oracle?

0 Answers  

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

0 Answers  

---