René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Selecting a few random records in a table in Oracle

Oracle has the sample keyword that can be used in select statements like shown below:
select * from <table> sample(0.2);
This statement will select approximatly 0.2 percent of the data in the table.
This feature requires the sample scan option.