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>