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.
- 7 Answers
- 8590 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
How do you declare a constant?
What does select * from mean in sql?
Explain spool.
How delete all data from all tables in sql?
How to download oracle sql developer?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How insert into statements in sql?
what is timestamp in mysql? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
what does myisamchk do? : Sql dba
how to see the create table statement of an existing table? : Sql dba
What are the constraints available in sql?
What are the properties of a transaction?
What is sql*plus?
Is progress software supports to ( pl/sql )?
