how can get like this result table A col1 col2 --- ----- a A b B

how can get like this result
table A
col1 col2
--- -----

a A
b B
C C
.. ..
.. ...
.. ...
wants result like for a single column

col1
------
a,b,c,........n of data

and

another is

col1
-------
A B C D ........
a b b d ........

Question Posted / plsqlganesh

2 Answers
4091 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... ..

Answer / ajit

select wm_concat(col1) col1
from t1;

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

Is This Answer Correct ?

1 Yes

0 No

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... ..

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;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer