Random string with dbms_random.string : DBMS_RANDOM « System Packages « Oracle PL / SQL






Random string with dbms_random.string

  

SQL> COLUMN mixed_up NEW_VALUE mixed_up_sub_var
SQL> SELECT dbms_random.string('X',30) mixed_up
  2  FROM dual;
3X0P1I67MKLZM7934O6JGUJSE3Q9A2

1 row selected.

SQL>
SQL> DEFINE mixed_up_sub_var
DEFINE MIXED_UP_SUB_VAR = "3X0P1I67MKLZM7934O6JGUJSE3Q9A2" (CHAR)
SQL>
SQL>
SQL>

   
    
  








Related examples in the same category

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.Seed a random value with dbms_random.seed
7.Round a random value from dbms_random.value
8.trunc a random value from dbms_random.value
9.mod(abs(dbms_random.random),50000)+1
10.Insert random numbers into a table
11.Insert random value to table