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

What is the benefit of foreign key?

1022

What are the uses of merge?

1167

What is plpgsql language?

1067

Where the sql database files are stored?

1021

How many developers work on postgresql?

985

what is top in tsql? : Transact sql

1122

What is 19 null in sql?

972

What is the location of pre_defined_functions.

1166

Is it mandatory for the primary key to be given a value when a new record is inserted?

1198

Explain clause in sql?

1034

What is inner join in sql?

1084

What is the difference between function, procedure and package in pl/sql?

1267

What is a record in a database?

1064

what are the nonstandard string types? : Sql dba

1144

Which join is like inner join?

1031