Answer / rajmohan

Yes a view can be based on another view.

How to connect the oracle server as sysdba?

0 Answers  

---

What are a cluster and non-cluster index?

0 Answers  

---

What privilege is needed for a user to create tables in oracle?

0 Answers  

---

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

---

---

"primary key=unique+null" is equal,reson?not,reason?

5 Answers  

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

0 Answers  

---

if you update view? where we store the data?

5 Answers   Cap Gemini,

---

Explain the concept of the DUAL table.

2 Answers  

---

how to get the second max val for every group in a table

6 Answers   Verizon,

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

0 Answers   CTS,

---

What is bulk copy or bcp in oracle?

0 Answers  

---