Like other programming languages, PL/SQL supports decision making statements, These statements are also called conditional statement
Basic Syntax of IF-ELSE is like this in PL/SQL
IF (Condition 1)
THEN
Statement to execute (if condition 1 is true)
ELSIF (Condition 2)
THEN
Statement to execute (if condition 2 is true)
ELSE
Statement to execute (if condition 1& 2 both are false)
END IF;
For a better understanding of concept look at these examples
