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-2275Fuelspot
73 Princeton Street
North, Chelmsford 01863
