CODE SQLPLUS

Question 1

Generieren und fügen 2 Mio Users in Tabelle hinzu!

Answer 1

BEGIN
FOR i IN 1..2000000
LOOP
INSERT INTO HR.TAB3(USER_ID, USER_NAME) VALUES(i, ‘user’);
IF MOD(i, 10000) = 0 THEN
COMMIT;
END IF;
END LOOP;
COMMIT;
END;