Oracle DB, generating sample data

useful commands:

INSERT INTO TEXTTEST (TEXTCOLUMN, NUMBERCOLUMN) SELECT DBMS_RANDOM.STRING('A',10), TRUNC(DBMS_RANDOM.VALUE(1111111111,9999999999)) FROM DUAL CONNECT BY LEVEL <=250000;