Oracle PL/SQL Tutorial/System Packages/DBMS RANDOM
DBMS_RANDOM.INITIALIZE and DBMS_RANDOM.RANDOM
<source lang="sql">
SQL> SQL> DECLARE
2 lv_seed_num PLS_INTEGER := 123456789; 3 lv_random_num PLS_INTEGER; 4 BEGIN 5 DBMS_RANDOM.INITIALIZE(lv_seed_num); 6 FOR lv_loop_num IN 1..5 LOOP 7 lv_random_num := DBMS_RANDOM.RANDOM; 8 DBMS_OUTPUT.PUT_LINE("Loop: " || lv_loop_num || 9 " Random Number: " || lv_random_num); 10 END LOOP; 11 DBMS_RANDOM.TERMINATE; 12 END; 13 /
Loop: 1 Random Number: 1476678237 Loop: 2 Random Number: -1196898280 Loop: 3 Random Number: -1383166668 Loop: 4 Random Number: 676298547 Loop: 5 Random Number: 1488158419 PL/SQL procedure successfully completed. SQL></source>
DBMS_RANDOM.RANDOM()
<source lang="sql">
SQL> SQL> SQL> SELECT DBMS_RANDOM.RANDOM()
2 FROM dual;
DBMS_RANDOM.RANDOM()
-1.612E+09
SQL></source>