Q: how to only select subset of qualified rows ?

Sir, Is there a way to only select a subset of qualified rows ? for example,
table has 10,000 rows
qualified rows 1000

select first 100 out 1000 qualified rows for update without going thru plsql loop. if using rownum, random, sample is the solution, how reliable they
are ? (I need to process all 1000 rows and cannot loss data).

Thanks in advance
ted

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 18:36:33 CST