A Dev Gym Workout

PIVOT and UNPIVOT Operators


Find out how to turn rows into columns and back again.

Read an article explaining the PIVOT and UNPVIOT operators from Tim Hall. Then take a series of quizzes on these clauses from Kim Berg Hansen, the Dev Gym's very own SQL quizmaster.

  • Instructor

    Tim Hall*

  • Estimated Time

    69 Minutes

  • Difficulty

    Intermediate to Advanced

Take Workout

Oracle Account Text

You need an Oracle Account to take a workout. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.

Exercises

Exercise Difficulty Time
PIVOT and UNPIVOT Operators in Oracle Database 11g Release 1Intermediate20
Using PIVOT and UNPIVOT: ExamplesNot Provided
Quiz on Pivoting OperationsIntermediate7
Quiz on Pivoting OperationsAdvanced6
Quiz on Unpivoting OperationsIntermediate8
Quiz on Unpivoting OperationsAdvanced18
Quiz on Pivoting OperationsIntermediate9
Take Workout
Instructor

*About Tim Hall

Tim Hall is an Oracle DBA/Developer and well known Oracle blogger at https://oracle-base.com. If that isn't enough, he's written two books and over 900 articles, is an Oracle ACE Director, Oracle Groundbreaker Ambassador, OakTable member, and has presented at numerous user groups and conferences worldwide.

More from Tim Hall