CASE statement is used to select one out of many set of statements to execute.
Types of CASE statements: