today:
149
yesterday:
311
Total:
1,018,388

IF/ELSE ... CASE WHEN

admin 2018.06.25 16:22 Views : 223

CREATE OR REPLACE PROCEDURE calsal
IS
   new_sal number;
   CURSOR sal_cursor
   IS
      SELECT deptno, empno, ename, sal
        FROM emp;
BEGIN
   FOR i IN sal_cursor
   LOOP
          if i.deptno = 10 then
               new_sal := i.sal *0.05 ;
           DBMS_OUTPUT.put_line (   ' Salary plus bonus of '
                            || i.empno
                            || ' is '
                            || (new_sal)
                           );
       elsif i.deptno = 20 then
               new_sal := i.sal *0.1 ;
           DBMS_OUTPUT.put_line (   ' Salary plus bonus of '
                            || i.empno
                            || ' is '
                            || (new_sal)
                           );
       else
                 new_sal := 0 ;
           DBMS_OUTPUT.put_line (   ' Salary plus bonus of '
                            || i.empno
                            || ' is '
                            || (new_sal)
                           );
       end if;
   END LOOP;
END;
No. Subject Author Date Views
106 TEST admin 2023.04.28 61
105 WHDR email address admin 2023.04.13 67
104 TEST admin 2023.03.27 120
103 GP 영수증 (3) -01/04/2023 admin 2023.01.04 65
102 GP - 영수증 (2) admin 2022.11.07 71
101 GP 영수증 본문 admin 2022.11.07 72
100 STARTUP admin 2022.09.01 109
99 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 167
98 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 158
97 SQL DEVELOPER file admin 2022.03.17 128
96 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 131
95 QRCODE admin 2020.05.25 412
94 JK admin 2019.02.05 717
93 ACTION admin 2019.01.11 6479
92 SELECT last_name FROM admin 2018.12.12 768
91 IMP admin 2018.10.08 745
90 CREATE TABLE admin 2018.09.25 491
89 Change Admin PASSWORD admin 2018.07.31 251
88 VERY IMPORTANT admin 2018.06.26 250
» IF/ELSE ... CASE WHEN admin 2018.06.25 223