How to use Pivot and Unpivot? (how to change rows to column and column to rows)

Опубликовано: 21 Октябрь 2024
на канале: Kishan Mashru
15,442
111

This is a video tutorial on using pivot and unpivot operators to change rows to column and columns to rows when needed, the video also demonstrates a way to change from rows to column without using the pivot operator which can be helpful if you are using and older version of oracle or some other database without the feature of pivot and unpivot. Both the operators are explained with an example for better understanding