in oracle, this can be done using heirarchical queries:

  select dbms_random.value from dual connect by level < 1000001;

edit: 1,000,001 as level starts with 1