Re: Kind of cool feature! DBMS_RANDOM

From: Anjan Thakuria <anjan.thakuria_at_eds.com>
Date: Thu, 06 Sep 2001 08:35:29 -0700
Message-ID: <F001.003854A3.20010906083551@fatcity.com>

Jack, Chris,
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:
 <span

class=250283722-05092001>Anjan,<span
class=250283722-05092001>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.<span class=250283722-05092001>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.<span class=250283722-05092001><span

class=250283722-05092001>Jack--------------------------------

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
japplewhite_at_inetprofit.com
(512)327-9068

-----Original
Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]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
 

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 Thu Sep 06 2001 - 10:35:29 CDT