CASE

CASE

SELECT

ENAME,

CASE 

  WHEN JOB='CLERK' THEN 2

  WHEN JOB='MANAGER' THEN 1

  ELSE 3

END "JOB_CLASS1",

CASE JOB

  WHEN 'CLERK' THEN 2

  WHEN 'MANAGER' THEN 1

  ELSE 3

END JOB_CLASS2

FROM EMP;

                       

DECLARE

  V_JOB INT :=&JOB;

  V_RESULT NUMBER(5,2);

BEGIN

  CASE V_JOB

    WHEN 1 THEN V_RESULT:=0.15;

    WHEN 2 THEN V_RESULT:=0.12;

    WHEN 3 THEN V_RESULT:=0.10;

    ELSE V_RESULT:=0;

  END CASE;

  DBMS_OUTPUT.PUT_LINE(TO_CHAR(V_RESULT,'FM9990.9999'));

END;