Oracle Interview Question: PIVOT and UNPIVOT

Sunday, 15 April 2018

Bothe the operators are used for transposing rows into column and vice versa.
PIVOT : rows to column
UNPIVOT :column to rows.

Oracle Database
Table Partitioning
Object Oriented Concepts in SQL
External Tables Concepts
Virtual Columns in Oracle 11g
Global Temporary Table(GTT)
Temporary Tablespace
Merge Statement
Oracle Data Pump
Pragma In Oracle
Function Return Multiple Values and Rows
Pipelined Table Functions
SYS_REFCURSOR and REF CURSOR
PIVOT and UNPIVOT
Collection element_type as CURSOR
Cursor-Based Records
Find the Object Dependencies
Update with RETURNING clause
Create CSV file using PL/SQL
ORA Error
PL/SQL one time only procedure