Pivot and Unpivot
This article shows how to use the PIVOT and UNPIVOT operators in Oracle 11g database, the keyword was introduced in that Oracle version. Before that you can get it by DECODE or CASE functions . UNPIVOT operator That operator transforms the data arranged on a column into separate rows. With this utility it is possible to convert…