17. Display the order number and average item cost for each order.

1 Answers   Wipro,

---

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

1 Answers   IBM,

---

Point the difference between translate and replace?

0 Answers  

---

What is an Index Segment ?

2 Answers  

---

How to start an oracle instance?

0 Answers  

---

Does rowid change in oracle?

1 Answers  

---

14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

1 Answers   Wipro,

---

What is oracle sid?

0 Answers  

---

What are different Oracle database objects?

1 Answers  

---

What is dynamic proxy?

0 Answers  

---

Can we protect our pl/sql source code?

0 Answers  

---

How to write date and time interval literals in oracle?

0 Answers  

---