Conditional statements are used to define what logic is
to be executed based on the status of some condition being satisfied.
There
are two types of conditional statements supported in SQL procedures:
CASE
IF
These statements are similar; however the CASE statements extends
the IF statement.
CASE statement in SQL procedures
CASE statements can be used to conditionally enter into
some logic based on the status of a condition being satisfied.
IF statement in SQL procedures
IF statements can be used to conditionally enter into some
logic based on the status of a condition being satisfied.