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  

---

can any one help me with import/export options in oracle............

1 Answers  

---

Explain the use of indexes option in exp command.

0 Answers  

---

How to start an oracle instance?

0 Answers  

---

What is a Shared SQL pool ?

2 Answers  

---

What is bind variable in oracle 11g?

0 Answers  

---

Give the advantages and disadvantages of clusters.

0 Answers  

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

0 Answers   MCN Solutions,

---

What are the commands youd issue to show the explain plan for select

2 Answers  

---

Can we use bind variables in oracle stored procedure?

0 Answers  

---

What are virtual columns?

2 Answers   TCS,

---

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,

---