Mega Code Archive
Trunc a random value from dbms_random value
SQL>
SQL> begin
2 for i in 1 .. 10 loop
3 dbms_output.put_line( trunc( dbms_random.value( 1, 101 ) ) );
4 end loop;
5 end;
6 /
15
17
28
52
25
19
55
35
18
48
PL/SQL procedure successfully completed.
SQL> --