VF=>user  ID=>     Login Feedback FAQ Blog
1,033,420 quizzes played | 1,641 active players

      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.


      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. :-)"

      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 TABLE plch_data (n NUMBER)
      /

      Which choices display "Empty table!" after execution?

      DECLARE
         l_n NUMBER;
      BEGIN
         SELECT n INTO l_n FROM plch_data;
      EXCEPTION
         WHEN NO_DATA_FOUND
         THEN
            DBMS_OUTPUT.put_line ('Empty table!');
      END;
      /
      
      BEGIN
         UPDATE plch_data SET n = 1;
      EXCEPTION
         WHEN NO_DATA_FOUND
         THEN
            DBMS_OUTPUT.put_line ('Empty table!');
      END;
      /
      
      BEGIN
         DELETE FROM plch_data WHERE n = 1;
      EXCEPTION
         WHEN NO_DATA_FOUND
         THEN
            DBMS_OUTPUT.put_line ('Empty table!');
      END;
      /
      
       
      About Oracle | Terms of Use | Your Privacy Rights | Copyright 2010-2016, Oracle Corporation