User Tools

Site Tools


kurs:einfacher_anonymer_block
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;
kurs/einfacher_anonymer_block.txt · Last modified: 2014/09/10 21:22 (external edit)