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 ........
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
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
types of indexes and the rationale behind choosing a particular index for a situation.
How to find the duplicate rows count from employees table in oracle?
Explain the use of owner option in exp command.
How to use fetch statement in a loop?
What do you mean by group by clause?
How to assign values to variables?
How do I uninstall oracle client from windows?
How many categories of data types in oracle?
What is oracle data type?
How to invoke the data pump import utility?
Explain the use of ignore option in imp command.
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?
How would you begin to troubleshoot an ORA-3113 error?
What are the ansi data types supported in oracle?