Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

what is view?

7 Answers   Accenture,

---

Explain the family trees and connection by clause

0 Answers  

---

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?

1 Answers  

---

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,

---

Which environment variables are absolutely critical in order to run the OUI?

0 Answers  

---

What are the different types of database objects?

0 Answers  

---

Tell me New Feature of Oracle 10g?

5 Answers   Thermotech,

---

What is a connect identifier?

0 Answers  

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

What is the Extension of Oracle Database? As extension of Access Database is .mdb

2 Answers  

---

what is difference between where clause and having clause?

13 Answers  

---