select cust, REPLACE(wm_conact(acc), ',', '|') as acc f

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

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

Answer Posted / bubun4u

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

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what is dbms?

1071

what is the functionality of the function htmlentities? : Sql dba

972

what are the drivers in mysql? : Sql dba

1032

Explain the insert into statements in sql?

1020

Can a trigger call a stored procedure?

1081

Explain ddl statements in pl/sql?

1015

What view means?

991

How to select all records from the table?

1156

What is sql key?

1001

Can we rollback truncate?

1011

What is rownum in sql?

1052

What does the acronym acid stand for in database management?

1047

What is sql clause?

1059

How to run pl/sql statements in sql*plus?

1095

What's the difference between a primary key and a clustered index?

997