Which Of The Following Is The Correct Syntax For The Case #514
Which of the following is the correct syntax for the CASE statement?
This multiple choice question (MCQ) is related to the book/course
gs gs115 Structured Query Language.
It can also be found in
gs gs115 PL/SQL Constants and Operators - PL/SQL Conditions - Quiz No.1.
Which of the following is the correct syntax for the CASE statement?
CASE selector IF 'value1' THEN Statement1; IF 'value2' THEN Statement2; IF 'value3' THEN Statement3; ... ELSE Statementn; END CASE;CASE selector WHEN 'value1' Statement1; WHEN 'value2' Statement2; WHEN 'value3' Statement3; ... ELSE Statementn; END CASE;CASE selector WHEN 'value1' THEN Statement1; WHEN 'value2' THEN Statement2; WHEN 'value3' THEN Statement3; ... ELSE Statementn; END CASE;CASE selector 'value1' THEN Statement1; 'value2' THEN Statement2; 'value3' THEN Statement3; ... ELSE Statementn; END CASE;
