Codebase list orafce / 7a230e7 debian / patches / big-endian
7a230e7

Tree @7a230e7 (Download .tar.gz)

big-endian @7a230e7raw · history · blame

--- /dev/null
+++ b/expected/dbms_random_1.out
@@ -0,0 +1,91 @@
+-- Tests for package DBMS_RANDOM
+SELECT dbms_random.initialize(8);
+ initialize 
+------------
+ 
+(1 row)
+
+SELECT dbms_random.normal()::numeric(10, 8);
+   normal    
+-------------
+ -0.37787769
+(1 row)
+
+SELECT dbms_random.normal()::numeric(10, 8);
+   normal   
+------------
+ 0.80499804
+(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 
+--------
+ IGXBB
+(1 row)
+
+SELECT dbms_random.string('P',2);
+ string 
+--------
+ R`
+(1 row)
+
+SELECT dbms_random.string('x',4);
+ string 
+--------
+ P1CB
+(1 row)
+
+SELECT dbms_random.string('a',2);
+ string 
+--------
+ yV
+(1 row)
+
+SELECT dbms_random.string('l',3);
+ string 
+--------
+ ccw
+(1 row)
+
+SELECT dbms_random.seed(5);
+ seed 
+------
+ 
+(1 row)
+
+SELECT dbms_random.value()::numeric(10, 8);
+   value    
+------------
+ 0.27474560
+(1 row)
+
+SELECT dbms_random.value(10,15)::numeric(10, 8);
+    value    
+-------------
+ 10.23233882
+(1 row)
+
+SELECT dbms_random.terminate();
+ terminate 
+-----------
+ 
+(1 row)
+