select wm_concat(col1) col1 from t1; select wm

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 / ajit

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2218

types of indexes and the rationale behind choosing a particular index for a situation.

2443

How to find the duplicate rows count from employees table in oracle?

1037

Explain the use of owner option in exp command.

989

How to use fetch statement in a loop?

970

What do you mean by group by clause?

977

How to assign values to variables?

1042

How do I uninstall oracle client from windows?

960

How many categories of data types in oracle?

952

What is oracle data type?

900

How to invoke the data pump import utility?

1079

Explain the use of ignore option in imp command.

974

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1937

How would you begin to troubleshoot an ORA-3113 error?

2022

What are the ansi data types supported in oracle?

894