ULTIMATE DATABASE

In example we set a variable called V_EXAMPLE to 1.

The IF command checks to see if it is less than or equal to zero, in which case it displays the text to say as such.
We then use ELSE to output the alternative solution which in this case if it is not less than or equal to zero it must be greater than zero.

In example we set a variable called V_EXAMPLE to 100.

The IF command checks to see if the variable V_EXAMPLE is less than or equal to zero, in which case we displays some text to say as such.
We then use an IF_ELSE command to check to see if V_EXAMPLE is between 1 and 99 and if it is we output text again to tell us.
If neither of these match our variable V_EXAMPLE then we output that V_EXAMPLE is greater than 100.

The ELSE command will now output that V_EXAMPLE is greater than 99 not because we have checked to see if V_EXAMPLE is greater than 99 but because it did not matched any of the previous IF commands.