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
10666 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

How we can update the view?

1099

Explain what is rdbms?

1091

How many types of triggers exist in pl/sql?

1137

How is a PL/SQL code compiled?

1283

How do I find duplicates in a single column in sql?

1070

where are cookies actually stored on the hard disk? : Sql dba

1080

What is a unique key and primary key and foreign key?

1023

how is exception handling handled in mysql? : Sql dba

1132

What does over partition by mean in sql?

1046

How do I view a procedure in sql?

1019

What is sql indexing?

1065

what are the differences between binary and varbinary? : Sql dba

1085

What are the subsets of sql?

1199

Is sql harder than python?

1159

What is cross join sql?

964