Give an example of Full Outer Join?

1 Answers   IBM,

---

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

---

What is the difference between partition and index?

0 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

What is the difference between truncate and drop statements?

0 Answers  

---

how to get help information from the server? : Sql dba

0 Answers  

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

---

what is row? : Sql dba

0 Answers  

---