8) Explain in your own words the following code in Figure 3. (HR SCEHMA). 117 DECLARE...

 

Transcribed Image Text:

8) Explain in your own words the following code in Figure 3. (HR SCEHMA). 117 DECLARE 118 deptno NUMBER := 90; 119 CURSOR emp_cursor IS 120 121 122 123 BEGIN 124 FOR emp_record IN emp_cursor 125 126 127 SELECT FROM WHERE 128 129 130 131 132 END; ELSE last_name, salary, manager_id employees department_id deptno; LOOP IF emp_record. salary < 5000 AND (emp_record.manager_id-101 OR emp_record.manager_id=124) THEN DBMS_OUTPUT.PUT_LINE (emp_record.last_name || Due for a raise'); DBMS_OUTPUT.PUT_LINE (emp_record.last_name || Not Due for a raise'"); END IF; END LOOP; = 8) Explain in your own words the following code in Figure 3. (HR SCEHMA). 117 DECLARE 118 deptno NUMBER := 90; 119 CURSOR emp_cursor IS 120 121 122 123 BEGIN 124 FOR emp_record IN emp_cursor 125 126 127 SELECT FROM WHERE 128 129 130 131 132 END; ELSE last_name, salary, manager_id employees department_id deptno; LOOP IF emp_record. salary < 5000 AND (emp_record.manager_id-101 OR emp_record.manager_id=124) THEN DBMS_OUTPUT.PUT_LINE (emp_record.last_name || Due for a raise'); DBMS_OUTPUT.PUT_LINE (emp_record.last_name || Not Due for a raise'"); END IF; END LOOP; =