Live ORACLE

DROP TABLE temp CASCADE CONSTRAINTS PURGE;

CREATE TABLE temp (
 emp_no     NUMBER,
 email_addr VARCHAR2(50));



DECLARE

 emp_count  NUMBER;

BEGIN

 SELECT COUNT(employee_id)

 INTO   emp_count

 FROM   employees;



 FOR i IN 1.. emp_count LOOP

   INSERT INTO TEMP

   VALUES     (i,

               'to be added later');

 END LOOP;



 COMMIT;

END;

/

Specifying a LOOP Range at Run Time