declare
e_id employee.employee_id%type;
e_first employee.first_name%type;
e_last employee.last_name%type;
cursor e_cursor is
select employee_id, first_name, last_name from employee;
begin
open e_cursor;
loop
fetch e_cursor
into e_id, e_first, e_last;
exit when e_cursor%notfound;
dbms_output.put_line('employee id :'
|| e_id || 'employee first name is : ' ||
e_first || 'employee last name is : ' ||e_last);
end loop;
close e_cursor;
end;
Comments
Post a Comment