[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

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.