제어문

--IF문

DECLARE

  l_sales NUMBER := 2500;

  l_bouns NUMBER := 0;

BEGIN

  IF l_sales >= 3000 THEN

    l_bouns := 300;

  ELSIF l_sales >= 2000 THEN

    l_bouns := 200;

  ELSE 

    l_bouns := 100;

  END IF;

  

  DBMS_OUTPUT.PUT_LINE('BOUNS: ' || l_bouns);

END;

/

-------------------------------------------------------------------------------------------------------------------------

--CASE문

DECLARE

  salary NUMBER := 1000;

  l_out VARCHAR2(20);

  l_out1 VARCHAR2(20);

BEGIN

  l_out :=

    CASE salary

      WHEN 3000 THEN 'Excellent'

      WHEN 1000 THEN 'Very Good'

      WHEN 500 THEN 'Good'

      ELSE 'Not Bad'

    END;

    

  l_out1 :=

    CASE 

      WHEN salary >= 3000 THEN 'Excellent'

      WHEN salary >= 1000 THEN 'Very Good'

      WHEN salary >= 500 THEN 'Good'

      ELSE 'Not Bad'

    END;

    

  DBMS_OUTPUT.PUT_LINE('OUT: ' || l_out || ', OUT1: ' || l_out1);

END;

/