Oracle : Convert a column into row in Oracle


In Oracle 11g database new functionality UNPIVOT to convert the column into rows.

My answer on stackoverflow.com on the same with example.

Advertisements