Re: Kind of cool feature! DBMS_RANDOM

2001-09-06 Thread Anjan Thakuria
racle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- 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: Ki

RE: Kind of cool feature! DBMS_RANDOM

2001-09-06 Thread Jamadagni, Rajendra
There is an example in Oracle Magazine Sept/Oct 2001, page 40. More info with example at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:123545815 6173 HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot

Re: Kind of cool feature! DBMS_RANDOM

2001-09-06 Thread Ron Rogers
: 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

RE: Kind of cool feature! DBMS_RANDOM

2001-09-06 Thread Christopher Spence
ge- 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 Hi Chris, Pl excuse me for writing d

Re: Kind of cool feature! DBMS_RANDOM

2001-09-05 Thread Anjan Thakuria
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

RE: Kind of cool feature! DBMS_RANDOM

2001-09-05 Thread Jack C. Applewhite
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

RE: Kind of cool feature! DBMS_RANDOM

2001-09-05 Thread Christopher Spence
No problem at all, I believe it is undocumented. If you do a desc you will see there are a few functions. String is pretty cool, just populated 10,000,000 rows in my test database with it. I placed it on my site under tips as it seems useful. -Original Message- To: Multiple