VF=>user  ID=>     Login Feedback FAQ Blog
1,013,007 quizzes played | 1,911 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. :-)"

      Important News!

      We've built a new "skin" for our quiz platform: the Oracle Dev Gym. We'd love to hear what you think of it. Click on the Dev Gym image on the right of your home page to check it out.


      Play This Week's Quizzes

      Already registered, ready to play? Then click on a button to be logged in and play the quiz right now.

      Try a Quiz!

      We are 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.

      I execute this statement:

      CREATE OR REPLACE FUNCTION plch_sunny RETURN VARCHAR2
      IS
      BEGIN
         DBMS_OUTPUT.PUT_LINE ('Sunny Summer');
         RETURN 'Sunny Summer';
      END;
      /

      Which choice displays "Sunny Summer" after execution

      BEGIN
         DBMS_OUTPUT.PUT_LINE (NVL ('Cold Winter', plch_sunny()));
      END;
      /
      
      BEGIN
         DBMS_OUTPUT.PUT_LINE (
            COALESCE ('Cold Winter', plch_sunny()));
      END;
      /
      
      DECLARE
         l_winter VARCHAR2(100) := 'Cold Winter';
      BEGIN
         DBMS_OUTPUT.PUT_LINE (
            CASE WHEN l_winter IS NULL THEN plch_sunny() END);
      END;
      /
      
       
      About Oracle | Terms of Use | Your Privacy Rights | Copyright 2010-2016, Oracle Corporation