IF-THEN-ELSE & CASE Expression in PLSQL

Simple IF Statement:

IF ELSIF ELSE Clause:

 

CASE Expressions:

·         A CASE expression selects a result and returns it.

·         To select the result, the CASE expression uses expressions. The value returned by these expressions is used to select one of several alternatives.

Case expression Example: