DECLARE v_employee_id dbms_labs.employees.employee_id%TYPE; v_job dbms_labs.employees.job_id%TYPE; BEGIN SEL

[answerhappygod]

DECLARE
v_employee_id
dbms_labs.employees.employee_id%TYPE;
v_job dbms_labs.employees.job_id%TYPE;
BEGIN
SELECT employee_id, job_id INTO v_employee_id,
v_job
FROM dbms_labs.employees
WHERE employee_id = 100;
DECLARE
v_employee_id
dbms_labs.employees.employee_id%TYPE;
v_job dbms_labs.employees.job_id%TYPE;

BEGIN
SELECT employee_id, job_id
INTO v_employee_id, v_job
FROM
dbms_labs.employees
WHERE employee_id =
103;


DBMS_OUTPUT.PUT_LINE(v_employee_id || ' is a(n) ' ||
v_job);
END;

DBMS_OUTPUT.PUT_LINE(v_employee_id || ' is a(n)
' || v_job);
END;
.Modify the code from above query to display the details of
employee 100 in the inner block. Use block labels as shown in the
example below as part of your query.