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

Which are the different character-manipulation functions in sql?

1110

what is dbms? : Sql dba

1034

What is a procedure in pl sql?

1286

What is indexes?

1115

What are the datatypes available in pl/sql ?

1151

Can we use joins in subquery?

1224

What is a Mapplet?

1194

Explain exception handling in pl/sql?

1081

What is left inner join in sql?

1091

What is right join in sql?

1154

What is the difference between truncate and drop statements?

1260

what are the security recommendations while using mysql? : Sql dba

1177

How do I add a primary key to a table?

1082

What is raid? How does it help storage of databases?

1133

what is sp_pkeys? : Transact sql

1203