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

When do we use triggers?

0 Answers  

write a query to find 4th max salary

7 Answers  

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

How do I view a view in sql?

0 Answers  

How to select unique records from a table?

0 Answers  

what is union, minus and interact commands? : Sql dba

0 Answers  

Does user triggers have entry for trigger with compilation errors?

0 Answers  

Which type of cursor is used to execute the dml statement?

0 Answers  

Which is faster view or stored procedure?

0 Answers  

What is the mutating table and constraining table?

0 Answers