Tuesday, November 11, 2008

Creating numbers range

Ordered range of numbers

select rownum r from dual connect by level <=max_number order by 1

Randomly ordered range of numbers

select rownum r from dual connect by level <=max_number order by dbms_random.value;

No comments:

Post a Comment