Sorry this Web site requires JavaScript to function properly

Coding Challenge

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

Nice work! Now login to start taking the weekly quizzes on SQL, PL/SQL, Database Design and more!

Great SQL quiz this week! I got it wrong, but I learned something new. 🙂

To display a Boolean value with DBMS_OUTPUT.PUT_LINE, you must first convert that Boolean to a string value.

BEGIN DBMS_OUTPUT.PUT_LINE (CASE WHEN plch_pkg.my_flag THEN FALSE END); END;

Which of the choices will display TRUE after execution?

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

Nice work! Now login to start taking the weekly quizzes on SQL, PL/SQL, Database Design and more!

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.

We are all aboutactive learning! Rather than passively read or watch, youtest your knowledgeby answering a quiz and (if you choose) competing with Oracle Database developers around the world for top ranking.

BEGIN DBMS_OUTPUT.PUT_LINE (plch_pkg.my_flag); END;

BEGIN DBMS_OUTPUT.PUT_LINE (CASE WHEN plch_pkg.my_flag THEN TRUE END); END;

The CASE statement converts a TRUE value to FALSE.

To display a Boolean value with DBMS_OUTPUT.PUT_LINE, you must first convert that Boolean to a string value.

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

What Players Say About the PL/SQL Challenge

Leave a Reply