Thanks. Don't get play with these a whole lot being on the production side. Both of your experiences with this sounds very exciting.
Need to do some research.
Thanks again.
Anjan
"Jack C. Applewhite" wrote:
Anjan,Look in Oracle_Home/RDBMS/admin for the dbmsrand.sql file. The package is better documented there, at least for the 8.1.6 release.I used it last year to generate a Session ID for a Web-accessible application to maintain state across a User's multiple page hits.Jack--------------------------------
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068-----Original Message-----Hi Chris,
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anjan Thakuria
Sent: Wednesday, September 05, 2001 5:26 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Kind of cool feature! DBMS_RANDOM
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
