Transforming rows into comma separated output [message #273517] |
Wed, 10 October 2007 14:25 |
decci_7
Messages: 68 Registered: March 2006
|
Member |
|
|
Hi,
I have a table which has data structure like below:
Quote: |
Name--------Template----Flag
===============================
Radio ------Electronics---1
CDPlayer----Electronics---1
VCD---------Electronics---1
Chair-------Furniture-----1
Sofa--------Furniture-----0
Bed---------Furniture-----0
|
Now my requirement is that I need a PL/SQL to check for the data in the table with Flag = 1 and display it in the below format:
Quote: |
Electronics=Radio,CDPlayer,VCD
Furniture=Chair
|
Is this possible using the PL/SQL?
Please let me know. This one is really urgent. Anly help will be highly appreciated.
Thanks!
|
|
|
|
|
|
|
|
Re: Transforming rows into comma separated output [message #273537 is a reply to message #273533] |
Wed, 10 October 2007 15:13 |
decci_7
Messages: 68 Registered: March 2006
|
Member |
|
|
Thanks Michel,
But all these functions are user built ... what i was looking for is any in-built oracle functionality which can do the same job ...
I already looked @ these functions before starting the post.
I'll try to implement it using the cursors ... anyways thanks for the help ... and putting this post into the "homework,training and certification" section without analyzing it ...
|
|
|
|
Re: Transforming rows into comma separated output [message #273604 is a reply to message #273537] |
Thu, 11 October 2007 01:21 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Yes it smells homework and as you didn't post any information about your searches nor your tries nor your Oracle version, there is nothing to analyze. It definitively smells homework on your first post.
Regards
Michel
|
|
|