System Packages Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. System Packages
  4. Seed a random value with dbms_random seed
SQL>
SQL>  set serverout on
SQL>  exec dbms_random.seed( to_char( sysdate, 'YYYYMMDD' ) );
PL/SQL procedure successfully completed.
SQL>  exec dbms_output.put_line( dbms_random.value );
.09697957992149808336891757660029645577
PL/SQL procedure successfully completed.
SQL>  exec dbms_output.put_line( dbms_random.value );
.07915501486927581930051571448998022468
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL>  set serverout on
SQL>  exec dbms_random.seed( to_char( sysdate, 'YYYYMMDD' ) );
PL/SQL procedure successfully completed.
SQL>  exec dbms_output.put_line( dbms_random.value );
.09697957992149808336891757660029645577
PL/SQL procedure successfully completed.
SQL>  exec dbms_output.put_line( dbms_random.value );
.07915501486927581930051571448998022468
PL/SQL procedure successfully completed.
SQL> --