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

I have a tablle like this:

cust acc
-----------
a 1
b 2
b 3
c 4
c 5
c 6

I Want below o/p:
cust acc
---------------
a 1
b 2|3
c 4|5|6

Please any one can you have any ideas share me.
I have urgent requirement.

Question Posted / trainedforjob

7 Answers
10661 Views
MTS, I also Faced
E-Mail Answers

Answer Posted / trainedforjob

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

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does the hierarchical profiler does?

1127

What is procedure and function in sql?

1045

Why are sql stored procedures used?

1095

How do you use collections in procedure to return the resultset?

2286

How does join work in sql?

1053

How do I start sql profiler?

1048

Explain ddl statements in pl/sql?

1051

Is a foreign key always unique?

983

What is pls_integer in pl sql?

1157

Can I join the same table twice?

1095

how to calculate expressions with sql statements? : Sql dba

1096

What is scope of pl sql developer in future?

1071

Does view store data in sql?

1042

What is the most restrictive isolation level? : Transact sql

1127

What is the process of debugging?

1127