[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Random text generation

If a sample is what you are seeking you can also do a loops = 50 or 100
and you will return that many records.

-----Original Message-----
From: George Jansen [mailto:GJANSEN@AFLCIO.ORG]
Sent: Monday, January 07, 2002 10:47 AM
To: SQR-USERS@list.iex.net
Subject: Re: Random text generation


If

1. Your requirement is to get a sample of the records

2. You are running on Oracle 8i or 9i

You can use the SAMPLE clause, e.g

SELECT emplid, name
FROM ps_personal_data
SAMPLE (.5)

would get ½ of one percent of the records. There are restrictions (no
joins), but they can be worked around.