Generate a function in Oracle that contains uppercase and lowercase characters and numbers

function createstring (n_num in number) return VARCHAR2 is

I integer default 0;

V_token varchar2 (+) default ';

Begin

While I < N_num loop

If MoD (Round (Dbms_random.value (1, 2), 2) > 0 Then

--Generate characters

if (MoD (Round (Dbms_random.value (1, 2), 2) > 0) Then

--Generate uppercase characters

V_token: = Concat (V_token,

Chr (+ floor (dbms_random.value (0, 26)));

Else

--Generate lowercase characters

V_token: = Concat (V_token,

CHR + floor (dbms_random.value (0, 26)));

End If;

Else

--Generate numbers

V_token: = concat (V_token,to_char (Floor (dbms_random.value (0, 10)));

End If;

I: = i + 1;

End Loop;

return v_token;

End

Generate a function in Oracle that contains uppercase and lowercase characters and numbers