How to select some columns from a table in oracle?

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 are the advantages of oracle 12c?

0 Answers  

---

What is merge in oracle?

0 Answers  

---

What is the difference between view and materialized view in Oracle?

0 Answers   MCN Solutions,

---

Can we convert a date to char in oracle and if so, what would be the syntax?

0 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

Does oracle charge for java?

0 Answers  

---

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  

---

What is the sql query to concatenate column values from multiple rows in oracle?

0 Answers  

---

How would you design a database for an e-commerce website?

1 Answers  

---

what are the diffeenes between oracle 9i,oracle 10g

2 Answers  

---