Limiting result set in Oracle

[Anon]

Try this:

select * from table where ROWNUM < 100

This limits the number of records fetched from the table to 100.