dokuwiki

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;