Use the WHERE ROWNUMBER < or > to get close to the results you want.
That's not correct. The psuedo-column to use is ROWNUM, not ROWNUMBER.
And you CANNOT use > as that operator doesn't work with rownum. As Tom says in the article you linked to
Also, a ROWNUM value is incremented only after it is assigned, which is why the following query will never return a row:
where ROWNUM > 1;
Because ROWNUM > 1 is not true for the first row, ROWNUM does not advance to 2. Hence, no ROWNUM value ever gets to be greater than 1.