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
5015 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

How to best split csv strings in oracle 9i?

1022

How to assign data of the deleted row to variables?

1055

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2044

What is open database communication (odbc) in oracle?

987

Does oracle charge for java?

1042

What is an oracle table?

969

What is a user account in oracle?

1103

What happens if you set the sga too low in oracle?

1117

What is archive log in Oracle?

1117

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2294

What do you understand by a database object?

1038

How to get a list of all background sessions in the database?

970

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2943

Is a rollback possible to any savepoint?

1070

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2334