Create a table with random values

Summary
To create a table(RANDOM_VALUES) with 100 for example random values, use the following script.
CREATE TABLE RANDOM_VALUES (ID NUMBER(3), col1 VARCHAR2(30));

BEGIN
    FOR i IN 1..100 LOOP
      INSERT INTO RANDOM_VALUES VALUES (i, ROUND(Dbms_Random.VALUE*100000));
    END LOOP;
    COMMIT;
  END;
  /
Reviews
Filters
Search