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  

---

Explain the use of constraints option in exp command.

0 Answers  

---

Explain the family trees and connection by clause

0 Answers  

---

How to restrict the duplicate records in table valuesets

2 Answers   IBM,

---

What is the sid in oracle?

0 Answers  

---

Explain the use of compress option in exp command.

0 Answers  

---

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  

---

What is a shared pool?

1 Answers  

---

find out first highest salary?

10 Answers   Verinon Technology Solutions,

---

What do you mean by merge in oracle and how can we merge two tables?

0 Answers  

---

What is key preserved table?

0 Answers  

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---