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
- 5147 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 |
How do I know if oracle is installed on windows?
what is a cartition product?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
How to use subqueries with the exists operator in oracle?
What is an oracle and why it is used?
IS it possible to built the oracle database without setting the kernal parameters?
Why use resource manager in Oracle?
Is primary key indexed by default in oracle?
How to select the name of employee who is getting maximum sal with out using subquery
Can you create a synonym without having a table?
How can I get column names from a table in oracle?
How to pass parameters to procedures in oracle?
Oracle General 
