-- Tests for package DBMS_RANDOM
SELECT dbms_random.initialize(8);
 initialize 
------------
 
(1 row)

SELECT dbms_random.normal();
       normal       
--------------------
 -0.377877688597918
(1 row)

SELECT dbms_random.normal();
      normal       
-------------------
 0.804998041043833
(1 row)

SELECT dbms_random.seed(8);
 seed 
------
 
(1 row)

SELECT dbms_random.random();
   random   
------------
 -632387854
(1 row)

SELECT dbms_random.seed('test');
 seed 
------
 
(1 row)

SELECT dbms_random.string('U',5);
 string 
--------
 XEJGE
(1 row)

SELECT dbms_random.string('P',2);
 string 
--------
 T9
(1 row)

SELECT dbms_random.string('x',4);
 string 
--------
 FVGL
(1 row)

SELECT dbms_random.string('a',2);
 string 
--------
 AZ
(1 row)

SELECT dbms_random.string('l',3);
 string 
--------
 hmo
(1 row)

SELECT dbms_random.seed(5);
 seed 
------
 
(1 row)

SELECT dbms_random.value();
       value       
-------------------
 0.274745596107095
(1 row)

SELECT dbms_random.value(10,15);
      value       
------------------
 10.2323388238437
(1 row)

SELECT dbms_random.terminate();
 terminate 
-----------
 
(1 row)