-- Tests for package DBMS_RANDOM
SET behavior_compat_options='display_leading_zero';
SET
SELECT dbms_random.initialize(8);
 initialize 
------------
 
(1 row)

SELECT dbms_random.normal()::numeric(10, 8);
   normal   
------------
 0.75384501
(1 row)

SELECT dbms_random.normal()::numeric(10, 8);
   normal   
------------
 0.75384501
(1 row)

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

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

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

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

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

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

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

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

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

SELECT dbms_random.value()::numeric(10, 8);
   value    
------------
 0.10901326
(1 row)

SELECT dbms_random.value(10,15)::numeric(10, 8);
    value    
-------------
 10.54506628
(1 row)

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