Conditionals/ loops/ case selectors(case expressions) UC

Conditionals/ loops/ case selectors(case expressions)

IF condition THEN
Statement;
ELSEIF condition THEN
Statement;
ELSE
Statement;
END IF;

IF statement only reflect to true(false || null)

case selector:
CASE
WHEN
Statement;
END CASE;
Single condition:
= ‘’
Multiple condition:
IN(‘ ‘, ‘ ‘)

NULLs
Yields null => statement will not excepted => not true