select cust,wmsys.wm_concat(acc) from tbl 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 / kpk

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

Answer Posted / kpk

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are rollup and cube in t-sql? : Transact sql

1104

How many times can we commit in a loop?

1026

Explain autonomous transaction.

1162

What is clause?

1158

What is cursor in pl sql?

1121

What will you get by the cursor attribute sql%rowcount?

1044

what is the difference between truncate and delete statement? : Transact sql

1073

What is dense_rank in sql?

993

What is difference between hql and sql?

1085

what is the difference between blob and text? : Sql dba

1027

What is sql stand for?

991

What is delete command in sql?

1121

What is a record in pl/sql?

1153

Why do we use triggers?

974

Enlist some predefined exceptions?

1065