Answer / a.brahmam

please i want display the result as :
1 2 3
4 5 6

Answer / nihar meher

select replace(wm_concat(c1),',',' '),replace(wm_concat(c2),',',' ') from t;

Answer / ramaraju

select c1 as c1 from t1
union
select c2 as c1 from t1;

try this one.

Answer / bhanuprakash d

select listagg(c1,' ') within group (order by c1) from T
union
select listagg(c2,' ') within group (order by c2) from T

what is a database transaction? : Sql dba

0 Answers  

---

Is sql sequential or random?

0 Answers  

---

Explain the difference between sql and mysql.

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

What are different types of triggers?

0 Answers  

---

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

---

Mention what are the benefits of pl/sql packages?

0 Answers  

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

Which is better trigger or stored procedure?

0 Answers  

---

What is the difference between jpql and sql?

0 Answers  

---

How do you use collections in procedure to return the resultset?

0 Answers  

---

Which kind of parameters cannot have a default value in pl sql?

0 Answers  

---