Using rownum in the where condition.

[pando]

I wasnt aware that the order of returning the rows depends on what data blocks are cached in the buffer.

Is this documented somewhere in the docs or some metalink note?