Learn how to rotate a table to present the one to many relation between two tables as a one to one relation and present all the matching records in a single row.

This story continues at
http://www.dbasupport.com/oracle/ora...ingTable.shtml