Using SQL UNPIVOT to prepare data for dynamic ADF Faces User Interfaces

(Lucas Jellema) The UNPIVOT operator was introduced in Oracle Database 11g – see for example: http://technology.amis.nl/blog/2421/the-oracle-11g-unpivot-operator-turning-columns-into-rows. In Oracle, the UNPIVOT operation is the process of turning Columns to Rows. Put simply, by applying the UNPIVOT

Read More - Register for Free Membership