Conditional statements in SQL procedures

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.