Вывести ФИО + id employees при помощи курсора

1)

DECLARE

CURSOR cur_emp is

select e.last_name

, e.first_name

, e.employee_id

from employees e;

BEGIN

for cur in cur_emp loop

dbms_output.put_line(cur.last_name || ' ' || cur.first_name || ' ' || cur.employee_id);

end loop;

END;

2)

DECLARE

   c_id customers.id%type; 

   c_name customerS.No.ame%type; 

   c_addr customers.address%type; 

   CURSOR c_customers is 

      SELECT id, name, address FROM customers; 

BEGIN 

   OPEN c_customers; 

   LOOP 

   FETCH c_customers into c_id, c_name, c_addr; 

      EXIT WHEN c_customers%notfound; 

      dbms_output.put_line(c_id || ' ' || c_name || ' ' || c_addr); 

   END LOOP; 

   CLOSE c_customers; 

END; 

/