RE: Kind of cool feature! DBMS

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Wed, 05 Sep 2001 16:00:21 -0700
Message-ID: <F001.00383F77.20010905154023@fatcity.com>

<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.

ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.comjapplewhite_at_inetprofit.com(512)327-9068

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Anjan ThakuriaSent:   Wednesday, September 05, 2001 5:26 PMTo: Multiple recipients of   list ORACLE-LSubject: Re: Kind of cool feature!   DBMS_RANDOMHi 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 <FONT
    size=-1>Fax:    (707) 885-2275
    Fuelspot <FONT
    face="Comic Sans MS">73 Princeton Street     North, Chelmsford
    01863
Received on Wed Sep 05 2001 - 18:00:21 CDT

RE: Kind of cool feature! DBMS_RANDOM