have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---

What is schema in sql?

0 Answers  

---

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

What is rowtype?

0 Answers  

---

Can a view be mutating? If yes, then how?

0 Answers  

---

---

Why cross join is used?

0 Answers  

---

What is scope of pl sql developer in future?

0 Answers  

---

What is a sql statement?

0 Answers  

---

What is flag in sql?

0 Answers  

---

What is data profiling in sql?

0 Answers  

---

What is the differnce between view and materialized view

4 Answers   TCS,

---

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,

---