Cool Unpivot Sql References. The oracle (11g+) syntax is similar but with a few more options, such as how to treat null values. For a complete description of the syntax for pivot, see.
Web with unpivot i am able to get name, marks properly, but not able to get the column name in the source table to the subject column in the desired result set. In a query, it is specified in the from clause after the table name or subquery. For this scenario, you can refer to this article:
