 DECLARE 
    TYPE NumTab IS TABLE OF emp.empno%TYPE; 
    TYPE NameTab IS TABLE OF emp.ename%TYPE; 
    enums NumTab; -- no need to initialize 
    names NameTab; 
 BEGIN 
    SELECT empno, ename BULK COLLECT INTO enums, names FROM emp; 
    FOR i in enums.FIRST..enums.LAST LOOP 
       DBMS_OUTPUT.PUT_LINE(enums(i) || ' ' || names(i)); 
    END LOOP; 
 END; 