DECLARE 
    CURSOR emp_cursor IS 
      SELECT employee_id, 
             last_name, 
             department_name 
      FROM   hr.employees, 
             hr.departments 
      WHERE  hr.employees.department_id = hr.departments.department_id 
             AND hr.employees.department_id = 80; 
--FOR UPDATE OF salary NOWAIT; 
BEGIN 
    FOR table_name IN emp_cursor LOOP 
        dbms_output.Put_line(table_name.employee_id 
                             ||' ' 
                             ||table_name.last_name 
                             ||' ' 
                             ||table_name.department_name); 

        COMMIT; 
    END LOOP; 
END; 

CREATE TABLE table_name ( empno NUMBER(5), ename VARCHAR(10), dname VARCHAR(10) );

DECLARE 
    CURSOR emp_cursor 
    IS 
      SELECT empno, 
             ename, 
             a.deptno, 
             dname 
      FROM   emp a, 
             dept b 
      WHERE  a.deptno = b.deptno 
             AND a.deptno = 10; 
--FOR UPDATE OF salary NOWAIT;  
BEGIN 
    FOR emp_rec IN emp_cursor LOOP 
        INSERT INTO table_name 
        VALUES     (emp_rec.empno, 
                    emp_rec.ename, 
                    emp_rec.dname); 

        COMMIT; 
    END LOOP; 
END; 

SQL> set serveroutput on;
SQL> DROP TABLE table_name purge
  2  /

Table dropped.

SQL>
SQL> CREATE TABLE table_name ( empno NUMBER(5), ename VARCHAR(10), deptno number(2))
  2  /

Table created.

SQL>
SQL> DECLARE
  2      CURSOR emp_cursor IS
  3        SELECT e.empno,
  4               e.ename,
  5               e.deptno
  6        FROM   emp e,
  7               dept d
  8        WHERE  e.deptno = d.deptno
  9        AND    e.deptno = 10;
 10  --FOR UPDATE OF salary NOWAIT;
 11  BEGIN
 12      FOR table_name IN emp_cursor LOOP
 13          INSERT INTO table_name
 14          VALUES     (table_name.empno,
 15                      table_name.ename,
 16                      table_name.deptno);
 17      END LOOP;
 18  END;
 19  /

PL/SQL procedure successfully completed.

SQL>
SQL> select * from table_name
  2  /

     EMPNO ENAME          DEPTNO
---------- ---------- ----------
      7782 CLARK              10
      7839 KING               10
      7934 MILLER             10

SQL>

FOR table_name IN emp_cursor LOOP