PL/SQL Conditions, IF-ELSE Conditional Statement

Sharing is Caring

PL/SQL Conditions

Like many other programming languages, PL/SQL supports decision making statements, These statements are also called conditional statement. Conditional statements work on basis of a predefined condition’s output

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

PL/SQL IF-THEN-ELSE Condition-

 

DECLARE 
--Variables
a integer :=20;
b integer :=30;
BEGIN 
--Condition Check
IF(a < b) 
THEN
-- If condition is true then print this
dbms_output.put_line('B is greater than A');
ELSE
-- If condition is false then print this
dbms_output.put_line('A is greater than B');
END IF;
END;

Output is –

PL/SQL IF-THEN-ELSIF Condition-

 

DECLARE 
--Variables
a integer :=20;
b integer :=10;
c integer :=25;
BEGIN 
--Condition 1 Check
IF(a < b and a < c) 
THEN
-- If condition 1 is true then print this
dbms_output.put_line('A is smallest');
--Condition 2 Check
ELSIF (b < a and b < c)
THEN
-- If condition 2 is true then print this
dbms_output.put_line('B is smalllest');
END IF;
END;

Output is-

 

PL/SQL IF-THEN-ELSIF-THEN-ELSE Condition-

 

DECLARE
--Variables
a integer :=20;
b integer :=10;
c integer :=5;
BEGIN
--Condition 1 Check
IF(a < b and a < c) 
THEN
-- If condition 1 is true then print this
dbms_output.put_line('A is smallest');
--Condition 2 Check
ELSIF (b < a and b < c)
THEN
-- If condition 2 is true then print this
dbms_output.put_line('B is smalllest');
ELSE
-- If condition 1 and 2 both are false then print this
dbms_output.put_line('C is smallest');
END IF;
END;

Output is-

PL/SQL Conditions

Cheers 🙂 Happy Learning

Related Posts

An Oracle ACE, Blogger, Reviewer, Technical Lead working on Oracle ADF

Leave a Reply

Your email address will not be published. Required fields are marked *