Pivot & Crosstab

http://thinkoracle.blogspot.com.br/2005/09/pivot-and-crosstab-queries.html