This script illustrates the use of the DBMS_RANDOM package. : DBMS_RANDOM « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. DBMS_RANDOM

This script illustrates the use of the DBMS_RANDOM package.

   

SQL>
SQL> set serveroutput on
SQL>
 First call RANDOM without initializing the seed.  This will
 raise ORA-1426.
SQL> BEGIN
  2    DBMS_OUTPUT.PUT_LINE(DBMS_RANDOM.RANDOM);
  3  END;
  4  /
503520765

PL/SQL procedure successfully completed.

SQL>
 Now initialize, and print out 10 random numbers.
SQL> BEGIN
  2    DBMS_RANDOM.INITIALIZE(12345);
  3    FOR v_Count IN 1..10 LOOP
  4      DBMS_OUTPUT.PUT_LINE(DBMS_RANDOM.RANDOM);
  5    END LOOP;
  6  END;
  7  /
-1817329670
-610488908
1775775349
-1974231734
-861483099
1044932800
1916512750
808190358
-1880806196
-1406274277

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.ROUND a DBMS_RANDOM.VALUE
2.Call dbms_random.normal to get a random number
3.Use dbms_random.string to create random string
4.dbms_random.value
5.Random string with dbms_random.string
6.Seed a random value with dbms_random.seed
7.Round a random value from dbms_random.value
8.trunc a random value from dbms_random.value
9.mod(abs(dbms_random.random),50000)+1
10.Insert random numbers into a table
11.Insert random value to table