Rows from nothing

By | August 6, 2010

Every now and again I will need to create multiple rows of dummy data for whatever reason. The following will generate 10 rows that contain the rownumber and a random 10 character lowercase string:

select rownum, dbms_random.string('l',10) rand_string
from dual
connect by level <= 10;

Output:

ROWNUM         RAND_STRING
1              ppwuuixwuj
2              icvidoofrl
3              hxkodzcdji
4              qzvbgmdwpj
5              hnurrfeqtd
6              qlzfdspyxe
7              qnwplopyes
8              yvtlczdofw
9              csojntrkze
10             ruklzscjqv

Leave a Reply

Your email address will not be published. Required fields are marked *

Turn on pictures to see the captcha *