oracledba.help

RandomString.sql

<- Scripts

-- RandomString.sql
COL "Random String" FORMAT a32
SELECT translate( dbms_random.string('a', 8),
       dbms_random.string('a',8),
       trunc(dbms_random.value(100000,999999))) "Random String" 
FROM dual;