PL/SQL Process Control statement if ELSE condition selection statement

If condition statement.

Basic structure of an IF conditional statement

IF < Boolean expressions > Then

PL/SQL and statements

END IF;

or IF < Boolean expression > Then

PL/SQL and statements

else other statements

END IF;

Declare
Cou Number: = &number;
Begin
If Cou >10 Then
Dbms_output.put_line (' cou= ' | | COU);
Elsif Cou<5 Then
Dbms_output.put_line (' Value less than 5 ');
Else
Dbms_output.put_line (' condition not satisfied ');
End If;
End

PL/SQL Process Control statement if ELSE condition selection statement