Answer / ajit

select wm_concat(col1) col1
from t1;

select wm_concat(col2)||chr(10)||
wm_concat(col1) col1
from t1;

Answer / suman rana

If you are using Oracle 11g Release 1 and above version,
following queries will work.

SELECT listagg (b, ',') WITHIN GROUP (ORDER BY 1) hh
FROM (SELECT 'A' a, 'a' b FROM DUAL
UNION
SELECT 'B', 'b' FROM DUAL
UNION
SELECT 'C', 'c' FROM DUAL);


WITH qry AS
(SELECT 'A' a, 'a' b FROM DUAL
UNION
SELECT 'B', 'b' FROM DUAL
UNION
SELECT 'C', 'c' FROM DUAL)
SELECT listagg (a, ' ') WITHIN GROUP (ORDER BY 1) FROM qry
UNION ALL
SELECT listagg (b, ' ') WITHIN GROUP (ORDER BY 1) FROM qry;

How to create a table interactively?

0 Answers  

---

What is a parameter file in oracle?

0 Answers  

---

How to login to the server without an instance?

0 Answers  

---

Name the three major set of files on disk that compose a database in Oracle?

0 Answers  

---

How do I find the database name in oracle?

0 Answers  

---

Can you drop an index associated with a unique or primary key constraint?

0 Answers  

---

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

2 Answers   Wipro,

---

How to estimate disk space needed for an export job?

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

What are advantages of dateset in datastage?

0 Answers   iGate,

---

What happens if the imported table already exists?

0 Answers  

---

What is difference between SUBSTR and INSTR?

1 Answers  

---