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