What is the quickest way to fetch the data from a table?

0 Answers  

---

Please explain the difference between outer join and inner join? With examples would be appreciable..!

6 Answers   IBM,

---

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

Can you use a commit statement within a database trigger?

4 Answers  

---

What is a shared pool?

1 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 tns name?

0 Answers  

---

How to load a large xml file?

0 Answers  

---

Describe the types of sub query?

0 Answers  

---

what is reindexing?

0 Answers   Tata Technologies,

---

how to we delete a row using varray

3 Answers   CTC,

---

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

2 Answers   Wipro,

---