I am getting responses from users when I give them a query to not repeat the column values
and also build comma separated column value if it is more than one for readablity.
suppose I have a report that has columns and data value as
account name order Product Type code value
zys limited 1-1A Computer Elec 1
zys limited 1-1A Computer Elec-Print 1
in the above report Product computer has got 2 type values and so we have 2 rows to represent the value but user wants to see the report as
account name order product type code value
zys limited 1-1A Computer Elec,Elec-Print 1
not repeat the column value and also comma separate the more than 1 value
I have oracle 11 g and may be some analytical functions can do this without much custom code.. can anyone help?