Answer / bubun4u

select cust, REPLACE(wm_conact(acc), ',', '|') as acc from table
group by cust

Answer / phanikumar

select cust,listagg(acc,'|') within group(order by acc) from
tbl group by cust;

Answer / kpk

select cust,wmsys.wm_concat(acc) from tbl group by cust;

Answer / rajgopal

select cust,wm_concate(acc) from table_name group by cust;

Answer / dinesh

select cust, listagg(acc,'|') WITHIN GROUP (ORDER BY ACC )as ACC from cust1 group by cust;




This LISTAGG Function is the concept of 11g release2. and
this is the best answer for this question.

Answer / prathibha

select customer_id,

MAX(CASE WHEN RNK MOD 8 = 1 THEN ACCOUNT_NO ELSE '' END) ||
MAX(CASE WHEN RNK MOD 8 = 2 THEN ',' || ACCOUNT_NO ELSE '' END) ||
MAX(CASE WHEN RNK MOD 8 = 3 THEN ',' || ACCOUNT_NO ELSE '' END)
AS ACCOUNT_NO
FROM
(
select customer_id,account_no, rank() over (partition by customer_id order by account_no) as rnk
from customer_account ) TEMP
GROUP BY 1


The above query is tested and it works.

Answer / trainedforjob

select cust, wm_conact(acc) as acc from table
group by cust

What's the difference between inner join and left join?

0 Answers  

What is Referential Integrity?

3 Answers   IBM,

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

What is cursor and why it is required?

0 Answers  

How do you modify a column in sql?

0 Answers  

what is dbms? : Sql dba

0 Answers  

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

what is the difference between union and union all? : Sql dba

0 Answers  

Can we use views in stored procedure?

0 Answers  

Is sql difficult?

0 Answers  

when is the use of update_statistics command? : Sql dba

0 Answers  

How to return an array from java to pl/sql?

0 Answers