31 lines
813 B
MySQL
31 lines
813 B
MySQL
|
CREATE TABLE exemple_table (
|
||
|
|
col1 INTEGER,
|
||
|
|
col2 INTEGER,
|
||
|
|
col3 INTEGER,
|
||
|
|
col4 VARCHAR2(20)
|
||
|
|
);
|
||
|
|
|
||
|
|
DECLARE
|
||
|
|
v_col1 INTEGER;
|
||
|
|
v_col2 INTEGER;
|
||
|
|
v_col3 INTEGER;
|
||
|
|
v_col4 VARCHAR2(20);
|
||
|
|
BEGIN
|
||
|
|
FOR i IN 1..1000000 LOOP
|
||
|
|
v_col1 := TRUNC(DBMS_RANDOM.VALUE(1, 1000));
|
||
|
|
v_col2 := TRUNC(DBMS_RANDOM.VALUE(1, 1000));
|
||
|
|
v_col3 := TRUNC(DBMS_RANDOM.VALUE(1, 1000));
|
||
|
|
v_col4 := DBMS_RANDOM.STRING('U', 10); -- 10 caractères aléatoires en majuscules
|
||
|
|
|
||
|
|
INSERT INTO exemple_table (col1, col2, col3, col4)
|
||
|
|
VALUES (v_col1, v_col2, v_col3, v_col4);
|
||
|
|
|
||
|
|
-- Commit toutes les 10 000 lignes pour éviter les problèmes de mémoire
|
||
|
|
IF MOD(i, 10000) = 0 THEN
|
||
|
|
COMMIT;
|
||
|
|
END IF;
|
||
|
|
END LOOP;
|
||
|
|
COMMIT;
|
||
|
|
END;
|
||
|
|
/
|