PL/SQL Conditional Statements

PL/SQL Conditional Statements

Conditional Statements are depending on the condition block need to be executed or not which is decided by condition.

If the condition is "true" statement block will be executed, if condition is "false" then statement block will not be executed.

if....then

if (condition) than

statements;

end if;

declare
a number; 

begin
number=10;
if (a<12)
dbms_output.put_line("Goog Morning");
end;

Goog Morning

if....else

if (condition) than
statements;

else

statements;

end if;

declare
a number; 

begin
number=10;
if (a<12)
dbms_output.put_line("Goog Morning");
else
dbms_output.put_line("Good Evening");
end if;
end;

Goog Morning