|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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.