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

How do I trace sql profiler?

0 Answers  

What is having clause in sql?

0 Answers  

Define the select into statement.

0 Answers  

What is the current version of sql?

0 Answers  

What is nvarchar max in sql?

0 Answers  

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

How can get second highest salary in sql?

0 Answers  

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

0 Answers  

What are analytic functions in sql?

0 Answers  

What sql does db2 use?

0 Answers  

What is a sql*loader control file?

0 Answers  

Can we join two tables without common column?

0 Answers