Creating dummy data !!

Just going through oracle blogs, and got focus on below site...http://www.oracle-developer.net/display.php?id=515

Most of the times when you are practicing Oracle or Informatica code, you require a dummy data to be available at table. Particularly when you are working on Performance testing of oracle and informatica, large data is required. How will you create it ? One way is insert some records, then take union of it and again union of it. and so on.. But this will create repetation of data in your table..

Best way is below

Create table test as

SELECT ROWNUM                     AS id

       ,      MOD(ROWNUM,2000)           AS grp

       ,      DBMS_RANDOM.STRING('u',5)  AS val

       ,      DBMS_RANDOM.STRING('u',30) AS pad

       FROM   dual

       CONNECT BY ROWNUM <= 1000000;

For dbms_random pkg, you can get more info at http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3181424400346795479