SQL for Oracle equivalent of MySQL's LIMIT clause

FROM: http://rifers.org/blogs/gbevin

select * from (
     select query.*, rownum rnum from (
          select table1.column1, table1.column2, … from table1, table2, … where … order by ...
     ) query where rownum <= 200 )
where rnum >= 100 order by rnum