Скачать или смотреть PL/SQL Tutorial 7 : IF-THEN-ELSIF Statement in PL/SQL

Welcome to the VIDEO 7 of PL/SQL

In these video We will learn about the IF-THEN-ELSIF conditional statement in PL/SQL.

Syntax:-

IF condition1 THEN
statements executed if condition1 is true;
ELSIF condition2 THEN
statements executed if condition2 is true;
.
.
.
ELSIF conditionN THEN
statements executed if conditionN is true;
ELSE
statements executed if all the above condition is false;
END IF;



1.Sometimes you want to choose between several alternatives.

2.You can use the keyword ELSIF (not ELSE IF) to introduce additional conditions.


3.If the first condition is FALSE, the ELSIF clause tests another condition.

4.An IF statement can have any number of ELSIF clauses; the final ELSE clause is optional.


5.Conditions are evaluated one by one from top to bottom.

6.If any condition is TRUE, its associated sequence of statements is executed and control passes to the next statement in the pl/sql block.

7.If all conditions are false, the sequence in the ELSE clause is executed.






step 1 declare
step 2 grade char:='B'
grade has a value B
step 3 begin
step 4 if grade='A' it prints Very Good
step 6 if grade='B' it prints Good
step 8 if grade='C' it prints Poor
step 10 if all the condition is false it prints no such grade

as you can see it prints Good because
grade='B' is true

Please SUBSCRIBE to our Channel

Thank you for Watching.