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