Hi Chris,
Pl excuse me for writing directly. I looked up this package and there
is no mention of the STRING option at all. Metalink search returned no
hits. Could you please send me the location where you got the information
from.
Thanks in advance
Anjan
Christopher Spence wrote:
In 8.1.6 Oracle added a new feature
which I don't believe is very well documented, it is great.
DBMS_RANDOM.STRING([OPT], [LEN]);
This will create a random string with
a length of up to 60 characters. Great for force populating tables.
The opt is for things like L, U, M
(Lower, Upper, Mixed case), there are a few different options.
One thing I did to force populate a
table is: DBMS_RANDOM.STRING('U', DBMS_RANDOM.VALUE(5, 10));
Which creates random string with random
length between 5 and 10 characters. Run 10,000,000 times, I got a
table with 30 columns and 10,000,000 random rows in no time.
"Do not criticize someone until you walked
a mile in their shoes, that way when you criticize them, you are a mile
a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707)
885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
Received on Wed Sep 05 2001 - 16:17:15 CDT
