Illustrates the case statement present into stored procedure

Question

Illustrates the case statement present into stored procedure?

Answer 1

CASE statement consists of a complex conditional construct. When a certain statement is evaluated as true therefore the search_condition ensures that the following statement gets executed. When there are no true statements are present, so the ELSE clause is executed. An error is produced when there is no statement.