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

Name the various constraints used in oracle?

1077

Explain an index segment?

1158

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2269

What is an oracle transaction?

1228

How to specify default values in insert statement using oracle?

1152

Explain what are the different type of segments?

1003

How do I limit the number of oracle database connections generated by weblogic server?

1115

What is an oracle table?

1031

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

1123

Differentiate between translate and replace?

1186

How many types of tables supported by oracle?

1118

Explain temporal data types in oracle

1133

How to use subqueries in the from clause in oracle?

1165

How to loop through data rows in the implicit cursor?

1118

interview questions with answer for cts

2635