DBMS_RANDOM « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. DBMS_RANDOM
1.ROUND a DBMS_RANDOM.VALUE
2.This script illustrates the use of the DBMS_RANDOM package.
3.Call dbms_random.normal to get a random number
4.Use dbms_random.string to create random string
5.dbms_random.value
6.Random string with dbms_random.string
7.Seed a random value with dbms_random.seed
8.Round a random value from dbms_random.value
9.trunc a random value from dbms_random.value




10.mod(abs(dbms_random.random),50000)+1
11.Insert random numbers into a table
12.Insert random value to table