oracle 11g new features

Pivot queries involve transposing rows into columns (pivot) or columns into rows (unpivot) to generate results in crosstab format

http://www.oracle-developer.net/display.php?id=506