Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. (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

Step: 1

The given code is written in PLSQL and is used to determine whether employees in a specific departme... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Biostatistics

Authors: Bernard Rosner

8th Edition

130526892X, 978-1305465510, 1305465512, 978-1305268920

More Books

Students also viewed these Programming questions

Question

What are the assumptions required of a multiple regression model?

Answered: 1 week ago