Question: 1 0 . Run the following anonymous block. It should execute successfully: DECLARE v _ emp _ lname employees.last _ name % TYPE; v _
Run the following anonymous block. It should execute successfully:
DECLARE
vemplname employees.lastnameTYPE;
vempsalary employees.salaryTYPE;
BEGIN
SELECT lastname, salary INTO vemplname vempsalary
FROM employees WHERE jobid ADPRES';
DBMSOUTPUT.PUTLINEvemplname vempsalary;
END;
a Modify the block to use ITPROG instead of ADPRES and rerun it Why does it fail this time?
Write your answer below.
b Now modify the block to use ITPRAG instead of ITPROG and rerun 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
