PL/SQL Conditional Statements


Prev Tutorial Next Tutorial

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 statement

Syntax

if (condition) than

statements;

end if;

Example

declare
a number; 

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

Output

Goog Morning

if....else

if else statement

Syntax

if (condition) than
statements;

else

statements;

end if;

Example

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;

Output

Goog Morning

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements