Question: 1 0 . Run the following anonymous block. It should execute successfully: DECLARE v _ emp _ lname employees.last _ name % TYPE; v _

10. Run the following anonymous block. It should execute successfully:
DECLARE
v_emp_lname employees.last_name%TYPE;
v_emp_salary employees.salary%TYPE;
BEGIN
SELECT last_name, salary INTO v_emp_lname, v_emp_salary
FROM employees WHERE job_id ='AD_PRES';
DBMS_OUTPUT.PUT_LINE(v_emp_lname ||''|| v_emp_salary);
END;
a) Modify the block to use IT_PROG instead of AD_PRES and re-run it. Why does it fail this time?
Write your answer below.
b) Now modify the block to use IT_PRAG instead of IT_PROG and re-run it. Why does it still fail?
Write your answer below.

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 Programming Questions!