TOC Pivoting in Oracle 10g / earlier versions Pivoting in Oracle 11g Pivoting in Oracle 10g / earlier versions Pivoting is used for changing rows into columns in a SQL Query (Crosstab). Suppose we have a table TEST_PIVOT with some data as below: And suppose we want to know number of SE, SSE, TL, PM in each team then we can get this by specifying the query: select DESIGNATION, max(decode(TEAM, 'A', … Read More
via Abhishek Gupta