Using IF...ELSIF to determine a grade : IF « PL SQL « Oracle PL / SQL






Using IF...ELSIF to determine a grade

    

SQL>
SQL> -- Using IF...ELSIF to determine a grade.
SQL> DECLARE
  2     variable_Score Number := 85;
  3     variable_LetterGrade Char(1);
  4  BEGIN
  5     IF variable_Score >= 90 THEN
  6          variable_LetterGrade := 'A';
  7     ELSIF variable_Score >= 80 THEN
  8          variable_LetterGrade := 'B';
  9     ELSIF variable_Score >= 70 THEN
 10          variable_LetterGrade := 'C';
 11     ELSIF variable_Score >= 60 THEN
 12          variable_LetterGrade := 'D';
 13     ELSE
 14          variable_LetterGrade := 'E';
 15     END IF;
 16          DBMS_OUTPUT.PUT_LINE('Your Letter Grade is: ' || variable_LetterGrade);
 17  END;
 18  /
Your Letter Grade is: B

PL/SQL procedure successfully completed.

SQL>
SQL>
           
         
    
    
    
  








Related examples in the same category

1.IF...ELSIF...ELSE... END IF
2.The IF statement contains more than one statement per condition.
3.IF THEN and END IF
4.Adding ELSE to the IF block
5.IF, ELSIF ELSE and END IF
6.Using nested IF statements
7.if then else
8.A conditional statement
9.Check number value in if statement
10.Exit a loop with condition
11.If ladder
12.Compare three variables with if statement
13.If count() is 0, insert data
14.If condition meets, throw exception
15.Nested if statement
16.If...then...Else
17.Using a Boolean variable instead of the comparison operation
18.An if-then-elsif-then-else statement where the first two comparisons are true and the third false
19.Create a function and call it in an if statement