What is the difference between Case and Searched Case statements?
What will be an ideal response?
The CASE statement is an alternative to the IF…THEN…ELSIF…END IF statement.
The statement begins with keyword CASE and ends with keywords END CASE. The
body of CASE contains WHEN clauses with values or conditions, and action statements. When a WHEN clause’s value/condition evaluates to TRUE, its action statements are executed. A statement with a value is known as a CASE statement, and a statement with conditions is known as Searched CASE statement. A CASE statement uses a variable_name as a selector, but a searched CASE does not use variable name as selector.
You might also like to view...
As an audience member asks a question, make eye contact and listen to the full question
Indicate whether the statement is true or false
List the three types of comparisons that enable the making of any decision.
What will be an ideal response?