File: dbms_random.sql

package info (click to toggle)
orafce 3.0.7-4
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 1,144 kB
  • ctags: 1,068
  • sloc: ansic: 7,504; sql: 5,841; lex: 1,040; makefile: 93; yacc: 80; sh: 9
file content (16 lines) | stat: -rw-r--r-- 506 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- Tests for package DBMS_RANDOM
SELECT dbms_random.initialize(8);
SELECT dbms_random.normal();
SELECT dbms_random.normal();
SELECT dbms_random.seed(8);
SELECT dbms_random.random();
SELECT dbms_random.seed('test');
SELECT dbms_random.string('U',5);
SELECT dbms_random.string('P',2);
SELECT dbms_random.string('x',4);
SELECT dbms_random.string('a',2);
SELECT dbms_random.string('l',3);
SELECT dbms_random.seed(5);
SELECT dbms_random.value();
SELECT dbms_random.value(10,15);
SELECT dbms_random.terminate();