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
5060 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 create a stored procedure in oracle?

1106

How to define an anonymous block?

1160

What are the different windows events activated at runtime ?

2901

What are the differences between blob and clob in oracle?

1089

How to drop an index?

963

What is oracle database client?

1035

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2465

How do I uninstall oracle client from windows?

1013

What is a table index?

1102

What is the difference between formal parameters and actual parameters?

1089

Explain what are synonyms used for?

1039

What is SQL Tuning Advisor in Oracle?

1184

What are transaction isolation levels supported by oracle?

1073

Are truncate and delete commands same? If so why?

1157

How to turn on or off recycle bin for the instance?

1085