Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

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>