declare v_first_name employees.first_name%TYPE; v_last_name employees.last_name%TYPE default 'Fay'; begin select first_name into v_first_name from employees where last_name = v_last_name; dbms_output.put_line(upper(v_first_name)); dbms_output.put_line(v_last_name); end;