Question: 8) Explain in your own words the following code in Figure 3. (HR SCEHMA). 117 DECLARE 118 deptno NUMBER := 90; 119 CURSOR emp_cursor

8) Explain in your own words the following code in Figure 3. 



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; =

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The given code is written in PLSQL and is used to determine whether employees in a specific departme... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!