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 is a sql driver?

0 Answers  

What is a column in a table?

0 Answers  

Can we write dml inside a function in sql server?

0 Answers  

What is scalar function in sql?

0 Answers  

how to decrement dates by 1 in mysql? : Sql dba

0 Answers  

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

what is the forward decleration in packages?

1 Answers  

What are transaction and its controls?

0 Answers  

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

Temporary table vs Table variable in sql server?

0 Answers   Wipro,

Give an example of Full Outer Join?

1 Answers   IBM,

What is dcl in sql?

0 Answers