Another Oracle Dev Gym workout for you...


The CASE expression was first added to SQL in Oracle Database 8i. Oracle Database 9i extended its support to PL/SQL to allow CASE to be used as an expression or statement. Tim covers all the basics in this ORACLE-BASE article. We add a link to the documentation as a reference, and then it's time to take some quizzes by Steven Feuerstein and others to test your knowledge of CASE in PL/SQL!


  • Instructor

    Tim Hall*

  • Estimated Time

    45 Minutes

  • Difficulty

    Beginner to Advanced

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.


Exercise Difficulty Time
CASE Expressions And StatementsBeginner20
CASE ExpressionsNot Provided
Quiz on Matching on NULL in WHEN ClauseBeginner6
Quiz on CASE in PL/SQLIntermediate5
Quiz on Datatype of Expressions Returned by CASEIntermediate2
Quiz on Differences Between SQL CASE and PL/SQL CASEIntermediate8
Quiz on CASE in PL/SQLIntermediate2
Quiz on Case ExpressionsAdvanced2

*About Tim Hall

Tim Hall is an Oracle DBA/Developer and well known Oracle blogger at 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