Interested to Buy Any Domain ? << Click Here >> for more details...
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 ........
- 2 Answers
- 4947 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suman rana
If you are using Oracle 11g Release 1 and above version,
following queries will work.
SELECT listagg (b, ',') WITHIN GROUP (ORDER BY 1) hh
FROM (SELECT 'A' a, 'a' b FROM DUAL
UNION
SELECT 'B', 'b' FROM DUAL
UNION
SELECT 'C', 'c' FROM DUAL);
WITH qry AS
(SELECT 'A' a, 'a' b FROM DUAL
UNION
SELECT 'B', 'b' FROM DUAL
UNION
SELECT 'C', 'c' FROM DUAL)
SELECT listagg (a, ' ') WITHIN GROUP (ORDER BY 1) FROM qry
UNION ALL
SELECT listagg (b, ' ') WITHIN GROUP (ORDER BY 1) FROM qry;
| Is This Answer Correct ? | 1 Yes | 1 No |
Explain about your project and its relation to the current job position you are applying to?
What is an oracle data file?
How you find out version of installed workflow?
How to Remove the 3rd highest salary person record from table?
What is blob datatype?
What are Schema Objects ?
what is the difference between first normal form & second normal form?
What is the parameter mode that can be passed to a procedure?
What is trigger associated with the timer ?
How can we find out the duplicate values in an oracle table?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What are the oracle built-in data types?
Oracle General 
