MANAGING ITERATIONS

DECLARE
V_ID NUMBER ;
BEGIN
SELECT (NVL(MAX(ID),0)+1) INTO V_ID FROM TEMP_TEST;
FOR X IN (
     SELECT FIRST_NAME, SECOND_NAME, THIRD_NAME, FAMILY_NAME, TICKET_CLASS_CODE FROM TEMP_TEST1  
        ) LOOP
INSERT INTO TEMP_TEST(FIRST_NAME, SECOND_NAME, THIRD_NAME, FAMILY_NAME, TICKET_CLASS_CODE,ID)
VALUES
(X.FIRST_NAME, X.SECOND_NAME, X.THIRD_NAME, X.FAMILY_NAME, X.TICKET_CLASS_CODE,V_ID);
V_ID := V_ID+1;      
END LOOP;
COMMIT;    
END;
/