VF=>user  ID=>     Login Feedback FAQ Blog
969,182 quizzes played | 1,713 active players

      Welcome to the PL/SQL Challenge!

      Take quizzes, explore the library, check out player rankings!

      What Players Say About the PL/SQL Challenge

      "I try every morning to answer the quiz before I start opening my work emails. It actually jump starts my brain in the morning!"

      "Thanks for this wonderful site. it has become a nice evening routine to answer the question and sharpen my skills."

      "I really appreciate Oracle providing these quizzes. I use them to improve my Oracle Database development skills, and to learn about features I have not yet taken advantage of."

      "Great SQL quiz this week! I got it wrong, but I learned something new. :-)"

      Try a Quiz!

      The PL/SQL Challenge is all about active learning: rather than passively read or watch, you test your knowledge by answering a quiz and (if you choose) competing with Oracle Database developers around the world for top ranking.

      Which of the choices displays "Nice" after execution?

      DECLARE
         l_value   NUMBER := 100;
      BEGIN
         DBMS_OUTPUT.put_line (
            DECODE (l_value, 100, 'Nice', 'Not so nice'));
      END;
      /
      
      DECLARE
         l_value   NUMBER := 100;
      BEGIN
         DBMS_OUTPUT.put_line (
            IF l_value = 100 
               THEN 'Nice' 
            ELSE 'Not so nice' 
            END IF);
      END;
      /
      
      DECLARE
         l_value   NUMBER := 100;
      BEGIN
         DBMS_OUTPUT.put_line (
            CASE l_value 
               WHEN 100 
                  THEN 'Nice' 
               ELSE 'Not so nice' 
               END);
      END;
      /
      
       
      About Oracle | Terms of Use | Your Privacy Rights | Copyright 2010-2016, Oracle Corporation