Shulou(Shulou.com)06/01 Report--

Function createString (n_num in number) return varchar2 is

I integer default 0

V_token varchar2 (50) default''

Begin

While i

0 then

-- generate characters

If (mod (round (dbms_random.value (1,2)), 2) > 0) then

-- generate uppercase characters

V_token: = concat (v_token

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

Else

-- generate lowercase characters

V_token: = concat (v_token

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

End if

Else

-- generate numbers

V_token: = concat (floor (dbms_random.value (0,10)

End if

I: = I + 1

End loop

Return v_token

End

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.