VF=>user  ID=>     Login Feedback FAQ Blog
1,024,704 quizzes played | 1,750 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.

      Which choices display "1000" after execution?

         DBMS_OUTPUT.put_line (POWER (10, 3));
         FUNCTION powerful (n IN NUMBER, to_power IN NUMBER)
            RETURN NUMBER
            l_return   NUMBER := n;
            FOR indx IN 1 .. to_power - 1
               l_return := l_return * n;
            END LOOP;
            RETURN l_return;
         DBMS_OUTPUT.put_line (powerful (10, 3));
         l_number   NUMBER;
         SELECT POWER (10, 3) INTO l_number FROM DUAL;
         DBMS_OUTPUT.put_line (l_number);
      About Oracle | Terms of Use | Your Privacy Rights | Copyright 2010-2016, Oracle Corporation