Another Oracle Dev Gym workout for you...

CASE in PL/SQL


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!

Information

  • Instructor

    Tim Hall*

  • Estimated Time

    59 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.

Exercises

Exercise Difficulty Time
CASE Expressions And StatementsBeginner20
CASE ExpressionsNot Provided5
Quiz on Matching on NULL in WHEN ClauseBeginner6
Quiz on CASE in PL/SQLIntermediate5
Quiz on Datatype of Expressions Returned by CASEIntermediate5
Quiz on Differences Between SQL CASE and PL/SQL CASEIntermediate8
Quiz on CASE in PL/SQLIntermediate5
Quiz on Case ExpressionsAdvanced5
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 Developer Champion, OakTable member and has presented at numerous user groups and conferences worldwide.

More from Tim Hall