Where can I add the if statement to print of something likedepartment they work, or how much money, or due for a raise
SQL> DECLARE
2 EMP_REC HREMPLOYEES%ROWTYPE;
3
4 BEGIN
5
6 DBMS_OUTPUT.PUT_LINE(‘—————————————‘);
7
8 LOOP
9 IF EMP_REC.DEPARTMENT_ID
10 WHEN 10 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT:Administration’);
11 WHEN 20 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT:MARKETING’);
12 WHEN 30 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT:PURCHASING’);
13 WHEN 30 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT: HUMANRESOURCES’);
14
15 WHEN 50 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT:SHIPPING’);
16 WHEN 60 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT:IT’);
17 WHEN 70 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT: PUBLICRELATIONS’);
18 WHEN 80 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT:SALES’);
19 WHEN 90 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT:EXECUTIVE’);
20 WHEN 100 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT:FINANCE’);
21 WHEN 110 THEN DBMS_OUTPUT.PUT_LINE (‘EMPLOYEE DEPARTMENT:ACCOUNTING’);
22 END
PayPal Gateway not configured
PayPal Gateway not configured