That will not work.
where
rownum between 2147483647 and 4294967294
will never return a value.
rownum is a pseudocolumn which always starts with 1 and counts the "RESULT".
If you say rownum > 1 then for the first record the result is false and the record is not returned and then rownum is not increased.
This is an oracle-sql restriction.
Greetings
Jens