I would like to randomize the values of x and y in the following query:
insert into tab1 values (chr(x)||chr(y)||);
This would allow me to populate random values of strings in this table. I plan to use several of these random generators (concatenated) to populate several hundred thousand records.
Is there a function in PL/SQL or SQL that would do this ? The Dbms_random does not have a range restriction (am I wrong?). I would need to restrict the range of the x and y to be 65-90 incl for the chr function to return me characters of the english-alphabet.
thanks for your help.
Click Here to Expand Forum to Full Width