Taking the values from rows and turning them into columns is a common request for Oracle DBA. Or the reverse – take values from columns and turn them into rows. These are easy in Oracle Database with the PIVOT and UNPIVOT operators. This video will show the ins and outs of these operations and cool tricks you can do with them.
Video producer: https://developer.oracle.com