The if...then...else statement is the equivalent of DECODE function within the procedural statements.
