select cust,wm_concate(acc) from table

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 / rajgopal

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

Answer Posted / rajgopal

select cust,wm_concate(acc) from table_name group by cust;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an inconsistent dependency?

1031

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

934

What is the max nvarchar size?

944

What is acid property in a database?

1016

How to fetch alternate records from a table?

1209

What are sql triggers used for?

980

How long it takes to learn pl sql?

996

differentiate between float and double. : Sql dba

1037

What type of database is cloud sql?

1084

Write a unique difference between a function and a stored procedure.

976

Can we connect to postgresql using sql developer?

982

What is the difference between a procedure and a function?

1084

What is sap sql?

960

What is delimiter in pl sql?

1038

What is schema in sql example?

1159