Oracle Pivoting Queries in TeamSQL
ORACLE PIVOTING QUERIES IN TEAMSQL
One interesting feature in Oracle is the PIVOT operator, which is available from Oracle version 11g. This feature is frequently used in data warehouse environments to solve cross queries in few lines of SQL code. In this article, we will explain how to use the PIVOT clause in Oracle to create powerful cross queries using TeamSQL.
First of all, what are cross queries or pivot tables ?. A pivot table is a table of statistics that summarize the data of a ...