Question: Copy and execute the following anonymous block. Then modify it to declare and use a single record instead of a scalar variable for each column.

Copy and execute the following anonymous block. Then modify it to declare and use a single record instead of a scalar variable for each column. Make sure that your code will still work if an extra column is added to the departments table later. Execute your modified block and save your code.

DECLARE

v_dept_id departments.department_id%TYPE;

v_dept_name departments.department_name%TYPE;

v_mgr_id departments.manager_id%TYPE;

v_loc_id departments.location_id%TYPE;

BEGIN

SELECT department_id, department_name, manager_id, location_id

INTO v_dept_id, v_dept_name, v_mgr_id, v_loc_id

FROM departments

WHERE department_id = 80;

DBMS_OUTPUT.PUT_LINE(v_dept_id || ' ' || v_dept_name || ' ' || v_mgr_id || ' ' || v_loc_id);

EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('This department does not exist');

END;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Databases Questions!