6th Example - IF Selection on PL/SQL

PL/SQL is a reliable programming language. AS well as other programming languages​​, PL/SQL also able to perform the selection operation. There are 2 types of selection operations on PL/SQL, the choice of IF and CASE WHEN selection. Here is an example of using IF selections on PL/SQL block:


DECLARE
        Var1 NUMBER;
        Hasil VARCHAR2(16);
BEGIN
        Var1 := &n1;
        IF Var1 >= 70 THEN
                        Hasil := 'Great';
        ELSIF Var1 >=60 AND Var1 < 70 THEN
                        Hasil := 'Good';
        ELSE
                        Hasil := 'Poor';
        END IF;
        DBMS_OUTPUT.PUT_LINE (Hasil);
END;
/

In the PL/SQL block above, there is a substitution variable that will receive number  input value. If the number entered >= 70 then output is great, if the input value is between 60 and 70 then the output is Good, other than that its output is Poor.

No comments

Powered by Blogger.