Oracle comes with packages, stored procedures, functions

SQL> descdbms_random: Querying stored procedures and functions under the Dbms_random package

A, value () is used to return a random number between two values, value (Low, high) SQL>SelectDbms_random.value () fromDual: The default is 0 to 10.0536824248407651SQL>SelectDbms_random.value (Ten, -) fromdual;29.2420951206225

B, Random () returns a value between 2 and 31-2 of the 31-times between the shaping numeric SQL>SelectDbms_random.random () fromdual; 2071097056SQL>SelectDbms_random.random () fromdual; -1589187025

C,string('parameter', length) produces a random string of SQL>SelectDbms_random.string('a',Ten) fromDual --All returns a case-insensitive letter string Edvkaqnwiisql>SelectDbms_random.string('u',Ten) fromDual --Upper returns an uppercase string Kpgnytwdgasql>SelectDbms_random.string('L',Ten) fromDual --Little Small Letter Zehtdserwwsql>SelectDbms_random.string('x',Ten) fromDual ---uppercase and digital 3z7dba4s8isql>SelectDbms_random.string('P',Ten) fromDual --Print All the characters that can be printed Vj|2~cwm"K

Oracle comes with packages, stored procedures, functions