mod(abs(dbms_random.random),50000)+1
SQL>
SQL> create table random ( x int );
Table created.
SQL>
SQL> begin
2 for i in 1 .. 100000
3 loop
4 insert into random values
5 ( mod(abs(dbms_random.random),50000)+1 );
6 end loop;
7 end;
8 /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL>
SQL> drop table random;
Table dropped.
SQL> --
Related examples in the same category