Here we will write a PL/SQL program for finding Grade of students using if…elsif…else statement
DECLARE
score Number;
Grade Char(1);
BEGIN
Score:=&Score;
IF Score >= 90 THEN
Grade := 'A';
ELSIF Score >= 70 THEN
Grade := 'B';
ELSIF Score >= 60 THEN
Grade := 'C';
ELSIF Score >= 50 THEN
Grade := 'D';
ELSE
Grade := 'E';
END IF;
dbms_output.Put_line('Your Grade is: ' ||Grade);
END;
/
Enter value for score: 72 old 5: Score:=&Score; new 5: Score:=72; Your Grade is: B