Home » SQL & PL/SQL » SQL & PL/SQL » horizontal reporting
horizontal reporting [message #188888] Tue, 22 August 2006 04:55 Go to next message
arangu
Messages: 5
Registered: July 2006
Location: chennai
Junior Member
I have a following report which was the outcome of a select statement :

Select distinct ecc,ecc_name,tax_rate from table1;

ecc ecc_name tax_rate
--- -------- --------

AAA01 ANIL COMPANY 16
AAA01 ANIL COMPANY 8
AAB02 BROWN BROS 16
AAB02 BROWN BROS 8
AAB02 BROWN BROS 24

But I need the report in the following format

ecc ecc_name tax_rate
--- -------- --------

AAA01 ANIL COMPANY 16,8
AAB02 BROWN BROS 16,8,24

How to do it? Is it possible.

Re: horizontal reporting [message #188892 is a reply to message #188888] Tue, 22 August 2006 05:11 Go to previous message
gbarbisan
Messages: 67
Registered: August 2006
Location: Treviso - Italy
Member
You could have a look at this link.

(credits to Tom Kyte)
Previous Topic: define statement in script
Next Topic: Executing a stored procedure
Goto Forum:
  


Current Time: Sat Dec 10 18:44:02 CST 2016

Total time taken to generate the page: 0.08130 seconds