SQL to Generate Random Numbers? 
Author Message
 SQL to Generate Random Numbers?

As part of a database-building project which I'm managing, I want to
enforce quality control standards for data-entry by selecting a
statistically-representative sample of records, which will be evaluated
against original, hardcopy documentation.  I've got a handle on things
like sample size and stratification, but, of course, in order to be a
representative sample, it must also consist of records selected randomly.
Is there any way to do this in SQL? (specifically, we're using SQL*PLUS in
ORACLE 6.0)  Is there, for example, a "random" number generator available
in SQL, which will allow the extraction of random records from the
database?  Any help would be much appreciated--thanks.
--
"On the Internet, everyone is guaranteed 15 minutes of flame."
        -what Andy Warhol MIGHT have said- if he wasn't dead, that is
***************************************************************************



Tue, 27 Aug 1996 01:35:21 GMT
 SQL to Generate Random Numbers?

I don't know how to build a random number generator on Oracle 6.  But,
since Oracle 7 implements procedures, I was able to write one.

LBT.
--


Windows is no longer a trademark of Microsoft Corporation.



Tue, 27 Aug 1996 02:50:51 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. EASY: SQL to generate a simple random number?

2. Generating Random Numbers in SQL Server 6.5 Stored Procedure

3. PL/SQL Generating a random number

4. generating a random number

5. How to generate random numbers!

6. Generating Random Numbers

7. generating a random number with duplicate records

8. Generating Random Numbers

9. Generating random numbers mixed with strings

10. How to generate a difficult random number.

11. need help - generating random numbers

12. generating random numbers


 
Powered by phpBB® Forum Software