Improve your PL/SQL skills with quizzes, workouts, and classes

PL/SQL is the premier language for running SQL in Oracle Database. With many SQL extensions to aid data processing, using PL/SQL effectively is key to building high-performing applications.

We've built Oracle Dev Gym to help you understand all the ins and outs of working with PL/SQL. With a library of thousands of quizzes, can find questions on all aspects of PL/SQL programming. If you want to go deep on a specific topic, we have a range of workouts. These include articles or videos introducing the topic, followed by a series of quizzes to test your understanding. We also offer free classes for guided learning on specific topics.

Try a quiz
You need an Oracle Account to join Oracle Dev Gym. Click here to sign up.

Take free PL/SQL quizzes online

Testing yourself is one of the few ways proven to help you learn faster. With hundreds of multiple choice PL/SQL quizzes to choose from, Oracle Dev Gym is the ideal place to train and enhance your PL/SQL knowledge.

Here's a sample PL/SQL quiz

Sample quiz (assume Oracle Database 10g Release 2 or higher)

Which of these blocks use the WHILE loop in a way that allows the code to compile and execute without error?

Choices - Select all that apply.

Choice 1

  DECLARE
     l_condition   BOOLEAN := TRUE;
     l_index       PLS_INTEGER := 1;
  BEGIN
     WHILE l_condition AND l_index IS NOT NULL
     LOOP
        l_index := NULL;
     END LOOP;
  END;

Choice 2

  DECLARE
     l_condition   BOOLEAN := TRUE;
     l_index       PLS_INTEGER := 1;
  BEGIN
     WHILE ( l_condition AND l_index IS NOT NULL )
     LOOP
        l_index := NULL;
     END LOOP;
  END;

Choice 3

  DECLARE
     l_condition   BOOLEAN := TRUE;
     l_index       PLS_INTEGER := 1;
  BEGIN
     WHILE l_condition AND l_index IS NOT NULL
        l_index := NULL;
     END LOOP;
  END;

Choice 4

None. PL/SQL does not offer a WHILE loop.

Choice 5

  DECLARE
     l_condition   BOOLEAN := TRUE;
     l_index       PLS_INTEGER := 1;
  BEGIN
     WHILE l_index
     LOOP
        l_index := NULL;
     END LOOP;
  END;

No Choice Correct (Collapsible)

No choice is correct.

Take this quiz

Workouts to train your PL/SQL muscles

Like physical exercise, regular training is key to peak performance. To help with this, we've built targeted workouts to help you get to grips with specific topics in PL/SQL. These training sessions include some introductory material followed by a series of quizzes.

Our top workouts

Free PL/SQL courses

Oracle Dev Gym includes complete classes to help you dive into specific details of PL/SQL.

These guided programs all include videos to introduce the topic followed by articles or Live SQL tutorials. Each module finishes with a series of quizzes to check your understanding.

All courses on Oracle Dev Gym include a free certificate of completion.

Our top PL/SQL classes

Start quizzing!

Oracle Dev Gym is the perfect place to practice your PL/SQL skills. With a vast library of quizzes you're sure to find some that suit your ability and needs. Sign-up for your free account and get training!

View quizzes